Index Details button

Click the Index Details button to show the following information in the Index Details dialog:

Table Name
The name of the table.
Index Name
The name of the index. The indexes most in need of reorganizing are listed first.
Index Type
The type of the index.
The Index Type can be one of the following values:
  • PKEY (primary key)
  • FKEY (foreign key)
  • UI (unique index)
  • UC (unique constraint)
  • NUI (non-unique index)
Index Level
The number of index levels in the index tree.
The index level and index density indicate whether or not an index needs to be reorganized. The number of levels in the index tree determines the number of input and output operations needed to access a row using the index.
Indexes with fewer levels are more efficient than indexes with greater numbers of levels. The density is a fraction between 0 and 1 providing an indication of how full each index page is on average.
An Index Level value of 1 is ideal. An index with an Index Level value of 4 or above or with a level value of 2 or 3 with an Index Density greater than 0.5 is a good candidate for reorganization.
Index Density
The index density and the index level indicate whether or not an index needs to be reorganized. (See the Index Level description above.)
State
The state of the index. Upon opening the Index Details dialog box, the state may show as being OK (does not need defragmentation) or Fragmented (requires refragmentation).
After it is reorganized, the state shows as Defragmented.

To reorganize a fragmented index, select the index in the dialog and click the Compress button.

Click the Close button to close the dialog.

Related topics

About fragmentation

Reorganize All button


More Information