SQL Server series: index maintenance

1. DBCC Showcontig

Displays fragmentation information for the data and indexes of the specified table. When you make a large number of modifications to a table or add data, execute this statement to view fragmentation information for the specified table or the data and index that is being displayed, whether it is fragmented or not.

Its syntax format:

DBCCShowcontig[({table_name | table_id | view_name | view_id} [, Index_name | index_id] ) ]     [with {[, [All_indexes] ]          [, [Tableresults] ]          [, [FAST] ]         [, [All_levels] ]          [no_infomsgs]         }    ]

Example:

When the scan density is 100%, it indicates that the table has no fragmentation information.

SQL Server series: index maintenance