When you first display the Indexes page, by default the top 50 indexes by size are displayed in the grid.
Columns include:
Owner
The owner of the index.
Table
The table that the index is associated with.
Index
The name of the index.
Type
The type of index.
Fill Factor
A percentage specifying how much to fill each leaf level page with data. The remaining percentage reserves free space for future growth, reducing the potential for page splits.
“0” means the index was created or rebuilt using the server default.
ID
The ID of the index.
Rows
The number of rows in the table.
Size MB
The size of the index at the time of its last statistics update, measured in megabytes.
Filter the results
You can filter the results by the following criteria:
- Top N Indexes
- Size or row count
- Index name
- Table name
To filter the results, type appropriate values into the fields above the Indexes grid (wildcards are supported) and click Apply Filter.