MS SQL Server Indexes Question:
Download Job Interview Questions and Answers PDF
Explain Indexes disadvantages?
Answer:
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.
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.
Download SQL Server Indexes Interview Questions And Answers
PDF
| Previous Question | Next Question |
| MS SQL Server index? | Do you know Clustered and Non-Clustered Index? |