MS SQL Server Indexes Interview Question:

Explain Indexes disadvantages?

Submitted by: Administrator

Use of intexes slow down Data modification operations (such as INSERT, UPDATE, DELETE).
Every time data changes in the table, all the indexes need to be updated.
Indexes need disk space, the more indexes you have, more disk space is used.
Submitted by: Administrator