Index Properties (Fragmentation Page)
Use this page to view the state of index fragmentation and reorganize the index.
Page fullness
Indicates average fullness of the index pages, as a percentage. 100% means the index pages are completely full. 50% means that, on average, each index page is half full.Total fragmentation
The logical fragmentation percentage. This indicates the number of pages in an index that are not stored in order.Average row size
The average size of a leaf level row.Depth
The number of levels in the index, including the leaf level.Forwarded records
The number of records in a heap that have forward pointers to another data location. (This state occurs during an update, when there is not enough room to store the new row in the original location.)Ghost rows
The number of rows that are marked as deleted but not yet removed. These rows will be removed by a clean-up thread, when the server is not busy. This value does not include rows that are being retained due to an outstanding snapshot isolation transaction.Index type
The type of index. Possible values are Clustered index, Nonclustered index, and Primary XML. Tables can also be stored as a heap (without indexes), but then this Index Properties page cannot be opened.Leaf-level rows
The number of leaf level rows.Maximum row size
The maximum leaf-level row size.Minimum row size
The minimum leaf-level row size.Pages
The total number of data pages.Partition ID
The partition ID of the b-tree containing the index.Version ghost rows
The number of ghost records that are being retained due to an outstanding snapshot isolation transaction.Reorganize Index
Select this check box to reorganize the index when OK is clicked.
See Also