Skip to content

Indexes Tab Page

This tab page displays the information on one single index at a time.

Grid

The segments of the index are shown in a grid, and their attributes U/C and DESC are displayed as well. The U/C information is retrieved from the attribute DF_INDEX_SEGMENT_CASE, and the DESC information is retrieved from the attribute DF_INDEX_SEGMENT_DIRECTION.

Current Index

This spinform shows the number of the current order in the datagrid. You can change the current order by clicking the up/down spin buttons or pressing the up/down arrow keys. Spinning skips the indexes that are not in use and stops when the last index is found. Indexes are present when the attribute DF_INDEX_NUMBER_SEGMENTS returns a value greater than zero.

Segments

The number of index segments that make up this index. The information is retrieved by using the DF_INDEX_NUMBER_SEGMENTS attribute.

Levels

The amount of levels in use by the current index. The information is retrieved by using the DF_INDEX_LEVELS attribute.

Keylength

The length in bytes of the current key (index). The information is retrieved by using the DF_INDEX_KEY_LENGTH attribute.

Buffers

This form shows the number of buffers currently in use for this index. The information is retrieved via the DF_INDEX_NUMBER_BUFFERS attribute.

Online

This checkbox is selected if the index is not a batch index. The information is retrieved from the DF_INDEX_TYPE attribute.

Primary Index

This checkbox is selected if the current index is the primary index for the currently opened table. The information is retrieved from the DF_FILE_PRIMARY_INDEX attribute.

Additional Information for SQL Databases

Index Type

  • Server
  • Client Only
  • Server Only
  • Temporary

Clustered

Checked when it is a clustered index.

Name

This is the index name and is only present when the option "Use Index Names" is selected.