sys.dm_db_index_physical_stats

Description

Returns size and fragmentation information for the data and indexes of the specified table or view in the SQL Server Database Engine. For an index, one row is returned for each level of the B-tree in each partition. For a heap, one row is returned for the each partition. For large object (LOB) data, one row is returned for the of each partition.

Syntax

IN_ROW_DATA