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
Other Resources
Creating Indexes (Database Engine)
Reorganizing and Rebuilding Indexes
sys.dm_db_index_physical_stats