Database | Indexes | Duplicate

A duplicate index adds an unnecessary additional cost in index maintenance. This report lists all duplicate indexes in the selected database.

It doesn't take INCLUDE columns into account when determining which indexes are duplicates, but these are listed in the report.

As always, use your own judgement and test thoroughly when deciding whether or not to drop an index.

What It ShowsComments
Object Name
Index columnsThe columns that make up the index
Index nameFor each combination of object and index columns, all indexes are listed that match exactly.
Include columnsFor each listed index, the INCLUDE columns are listed so you can decide whether or not they really are duplicates.

This picture shows one of the missing indexes expanded to show the creation script.

< Database | Indexes | Redundant Database | Indexes | Statistics >