Creating Indexes on Multiple Columns

Question

What happens if you create an index on each column of a database table

Answer

Query optimizer can choose from all existing indexes and come up with an efficient execution plan which in turn improves performance. On the other hand data modification operations such as insert, update and delete will become slow because indexes need to be updated accordingly. In addition to that extra disk space is needed to store index data structures.

Leave a Reply