GilaMonster (5/10/2013)
sqlnaive (5/10/2013)
I was checking in my database and found lots of unused indexes. I found it based on summing up the index seeks, index scans and index lookups and comparing this with index updates. Now with this data and by checkig at the number of indexes within the table, I can say which index is not required and is only adding cost by only getting used in writes.Absolutely sure? Over what period have you done that index analysis? A couple months? Included the year end process? Other reports only run occasionally?
Gail, It has been around an year or little more than that. The tables on which these indexes are, getting used on daily basis. And I'm sure that these indexes are not getting used as the clustered indexes on these tables contains the columns which are there in randomly created small small non clustered indexes.