<< Click to Display Table of Contents >>

Navigation:  Health Check >


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.