Duplicate Indexes
The duplicate indexes has several options in the Ribbon. Selecting Exact match will report on duplicate indexes
where
•Both Index types are the same eg. non clustered index
•The covering index columns are the same
•The columns in both indexes have the same ordering (ascending/descending)
•Disabled indexes are ignore.
•The option to ignore duplicates is the same
•Both indexes are either unique or not unique
•The comparison is only on indexes not unique constraints.
Uncheck the Exact match and select items to ignore on the duplicate index comparison
In this example the comparison ignores:
Index Type and Unique
