This query returns redundant indexes.
An index is considered redundant if there is at least one other index for the same table or view which contains at least the same index keys (in the same order) and at least the same included columns. This query compares only non-clustered indexes, and it does not take into account the uniqueness of the indexes as well as the filter condition of filtered indexes (although it displays this information for each index).
For more information about this script: http://madeira.sqlserverradio.co.il/get-rid-of-redundant-indexes/
Comments