A redundant index is one that is covered totally by another index. What this means is that an index on column a is redundant if there is another index on columns a and b.
As with most things "it depends". The two indexes may have different INCLUDE columns, or the "superior" index may be very lengthy and specialized - designed to help one particular query.
So look at the output of this report - but don't blindly follow its recommendations. As always, use your own judgement and knowledge of the database design.
This report is split into 2. A list of indexes where the superior indexes have identical INCLUDE columns, and another list where the INCLUDE columns do not match.
|What It Shows||Comments|
|Index columns||The columns that make up the index|
|Include columns||The INCLUDE columns that are stored at leaf level only|
|Superior index||One or more superior indexes may be listed for each redundant index, along with their index columns and INCLUDE columns.|