Get a detailed list of indexes, including type, size, amount of fragmentation, and other attributes. Detect index and table fragmentation, including clustered index fragmentation, nonclustered index ...
@BADIndex BIT = 1, -- Set to 1 to include analysis of bad non-clustered indexes @MissingIndex BIT = 1, -- Set to 1 to include analysis of missing indexes ...