GilaMonster (5/13/2013)
sqlnaive (5/13/2013)
One more thing, even if these indexes are getting used, the stats from dmv sys.dm_db_index_usage_stats says that index_seek+index_scan_index_lookups are almost none as compared to index_write. The question here is also that should we consider these stats or not ?Depends how long you've tracked those stats for. They're not persistent.
Thanks Gail as always. These details are from quite long. So I'm considering performing the action based on these stats. 🙂