Hi,

I have another query that offers nearly the same output but what I miss here are two informations.

is_unique (sys.indexes) because sometimes you do have an unique index for consistency even if it is expensive.

And the size of the index (I take it from sys.dm_db_partition_stats) so you may see if the index is necessary or not. If the Clustered has a size of lets say 1 GB, a specific index may be pretty good even if the ratio between seek and updates is 1/100.

And if there are thousands of scans on a table with one page it does not matter or at least at the moment.

Thanks for sharing this script, it helps to find the bad guys out there that are torturing the servers 😉