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

Help and Information

Getting SQL Server 2005 Assistance