Running Microsoft SQL Server Profiler every now and then, it suggests me with a bunch of new indexes and statistics to create ("...97% estimated improvement...").
From my understanding every added index can make an SQL SELECT
query faster but also an UPDATE
or INSERT
query slower since the indexes have to be adjusted.
What I wonder is, when do I have "too many" indexes/statistics?
Maybe there is no clear answer on this but some rule-of-thumb.
UPDATE
andINSERT
statements too slow.