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 Shows||Comments|
|Index columns||The columns that make up the index|
|Index name||For each combination of object and index columns, all indexes are listed that match exactly.|
|Include columns||For 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 >