Too many indexes = slower writes.
Why
Every INSERT/UPDATE must update all indexes.
Rule
Indexes are not free.
Audit
sys.dm_db_index_usage_stats
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Too many indexes = slower writes.
Why
Every INSERT/UPDATE must update all indexes.
Rule
Indexes are not free.
Audit
sys.dm_db_index_usage_stats