Indexing on a column or group of columns of a table can improve the performance of update operations in a database,but it slows down the retrieval process of queries.

Question

Quizplus · Accepted Answer

Indexing on a column or group of columns of a table can improve the performance of retrieval (select) operations in a database. However, it can slow down the performance of update and insert operations as the index needs to be updated along with the table.

Indexing on a Column or Group of Columns of a Table