999 Non-Clustered Indexes on a Table – a good idea?
Every index in SQL Server can improve your query performance, if the Query Optimizer chooses the index in the execution plan for data retrieval. But on the other hand every index will also hurt your performance, because the index has to be maintained during INSERT, UPDATE, and DELETE operations. Therefore it is very important to …
999 Non-Clustered Indexes on a Table – a good idea? + read more
