Export (0) Print
Expand All

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft