Indexes
Use this page to view information about indexes for a collection or for a system catalog table in a database.
When the Index Details option is selected in the Show list, the following information is displayed:
- Owner
- The owner of the index.
- Columns
- The columns on which the index is defined. A column name, followed by a number in parentheses, indicates the number of bytes that are indexed in that column, starting with the first byte. For example, company(3) indicates that the first 3 bytes in the company column are indexed.
- Unique
- An indicator of whether the index accepts only unique values in the indexed column or set of columns, or allows duplicate values. A check mark indicates that the index accepts only unique values.
- Type
- Clustered
- An index in which the rows of the table are reordered as the index designates.
- B-tree
- An index that is arranged as a hierarchy of pages. B-tree indexes include forest of trees indexes.
- R-tree
- An index for columns that contain spatial data such as maps and diagrams.
- Basic text search
- A basic text search index. Basic text search indexes include XML indexes.
- Constraint
- An indicator of whether the index is associated with a constraint. A check mark indicates that it is. To see the name of the constraint, move the cursor over the check mark. The database server enforces a unique or primary key constraint on a table through a unique index.
- Enabled
- An indicator of whether the index is enabled. A check mark indicates that the index is enabled.
- Collation
- The collation order that the index uses when sorting or comparing character strings. The value of the collation is a locale; for example, en_US.819, de_de.8859-1, fr_fr.8859-1, or ja_jp.sjis.
When the Performance Details option is selected in the Show list, the following information is displayed:
- Columns
- The columns on which the index is defined. A column name, followed by a number in parentheses, indicates the number of bytes that are indexed in that column, starting with the first byte. For example, company(3) indicates that the first 3 bytes in the company column are indexed.
- Levels
- The number of levels in B-tree indexes.
- Leaves
- The number of leaves.
- Unique Keys
- The number of unique keys in the first column.
- Last Statistics
- The date and time when the statistics for the index were last recorded.
- Statistics Build Duration
- The time required to calculate the statistics for the index.