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
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.