naweed.akhtar (7/19/2011)
Which column is the 'number of reads' column?
There's actually 3 columns to look at in the query, all are from dm_db_index_usage_stats:
USER_SEEKS, USER_SCANS, USER_LOOKUPS. When those 3 numbers are all 0 or very low, then consider if you really need this index.