I have a very heavily queried large table. This table is about 95% read from and 5% written to. The table has 9 indexes some of which are used as covering indexes in queries that have to be very fast.
I would like to see if I can eliminate some of these indexes and I was wondering how I can determine how much a certain index is used to decide whether there are any obsolete indexes that just take up space and slow inserts down.
I do not want to use the Index tuning wizards ad would like to avoid running large jobs just ot determine usage. Any ideas ?