<< Click to Display Table of Contents >> Navigation:  Health Check > Indexes

Index Health check

 

The health check for indexes is broken out into

 

Non Unique Clustered Indexes

Duplicate indexes- indexes with the same columns and column ordinal position

Overlapping Indexes- indexes where the columns overlap eg. on a table there are 2 indexes, index A has key columns X,Y, index B has key columns X,Y,Z. In this case columns X,Y overlap.

 

 

Banded Grids

 

Index: Duplicate

Index: Overlap

 

 

The above banded grids have a similar structure

 

After the Main Band showing the table information. each of the other bands have columns 1,2 to identify and compare the 2 indexes. Banding the information makes comparison easier.