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

Help and Information

Getting SQL Server 2005 Assistance