Many devs think more indexes = faster queries.
Nope.
⚠ Real Risks
-
Inserts slow down
-
Updates slow down
-
Deletes slow down
-
Database size explodes
-
Memory grants skyrocket
-
Locking increases
✔ The Life-Saving Rule
Every index must support a query.
If the query does NOT exist → the index should NOT exist.
✔ How To Check
Query sys.dm_db_index_usage_stats:
SELECT * FROM sys.dm_db_index_usage_stats WHERE user_seeks = 0 AND user_scans = 0;
Unused index → DELETE IT.
Your DB will fly.