Purpose
The DBA_INDEXES view displays the indexes on all tables in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
USER_INDEXESALL_INDEXES
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the index. |
| INDEX_NAME | VARCHAR2(128) | NO | The name of the index. |
| INDEX_TYPE | VARCHAR2(27) | NO | The type of the index. |
| TABLE_OWNER | VARCHAR2(128) | NO | The owner of the indexed object. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the indexed object. |
| TABLE_TYPE | CHAR(5) | NO | The type of the indexed object. |
| UNIQUENESS | VARCHAR2(9) | NO | Indicates whether the index is unique. |
| COMPRESSION | VARCHAR2(13) | NO | Indicates whether the index is compressed. |
| PREFIX_LENGTH | NUMBER | NO | The number of columns in the prefix of the compressed index. At present, this column is not supported and is NULL by default. |
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace containing the index. |
| INI_TRANS | NUMBER | NO | The initial number of transactions. At present, this column is not supported and is NULL by default. |
| MAX_TRANS | NUMBER | NO | The maximum number of transactions. At present, this column is not supported and is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | The size of the initial extent. At present, this column is not supported and is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | The size of secondary extents. At present, this column is not supported and is NULL by default. |
| MIN_EXTENTS | NUMBER | NO | The minimum number of extents allowed in the segment. At present, this column is not supported and is NULL by default. |
| MAX_EXTENTS | NUMBER | NO | The maximum number of extents allowed in the segment. At present, this column is not supported and is NULL by default. |
| PCT_INCREASE | NUMBER | NO | The percentage increase in extent size. At present, this column is not supported and is NULL by default. |
| PCT_THRESHOLD | NUMBER | NO | The percentage of block space allowed for each index. At present, this column is not supported and is NULL by default. |
| INCLUDE_COLUMN | NUMBER | NO | The column ID of the last column in the primary key of the index-organized table. At present, this column is not supported and is NULL by default. |
| FREELISTS | NUMBER | NO | The number of process freelists allocated to each segment. At present, this column is not supported and is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | The number of freelist groups allocated to each segment. At present, this column is not supported and is NULL by default. |
| PCT_FREE | NUMBER | NO | The minimum percentage of free space in a block. At present, this column is not supported and is NULL by default. |
| LOGGING | VARCHAR2(3) | NO | Indicates whether logs are recorded for changes to the index. At present, this column is not supported and is NULL by default. |
| BLEVEL | NUMBER | NO | The B*-tree level. At present, this column is not supported and is NULL by default. |
| LEAF_BLOCKS | NUMBER | NO | The number of leaf blocks in the index. At present, this column is not supported and is NULL by default. |
| DISTINCT_KEYS | NUMBER | NO | The number of distinct indexed values. At present, this column is not supported and is NULL by default. |
| AVG_LEAF_BLOCKS_PER_KEY | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| AVG_DATA_BLOCKS_PER_KEY | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| CLUSTERING_FACTOR | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| STATUS | VARCHAR2(8) | NO | Indicates whether a nonpartitioned index is VALID or UNUSABLE. |
| NUM_ROWS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| LAST_ANALYZED | DATE | NO | At present, this column is not supported and is NULL by default. |
| DEGREE | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| INSTANCES | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| PARTITIONED | VARCHAR2(3) | NO | Indicates whether the index is a partitioned index. |
| TEMPORARY | VARCHAR2(1) | NO | At present, this column is not supported and is NULL by default. |
| GENERATED | VARCHAR2(1) | NO | At present, this column is not supported and is NULL by default. |
| SECONDARY | VARCHAR2(1) | NO | At present, this column is not supported and is NULL by default. |
| BUFFER_POOL | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| DURATION | VARCHAR2(15) | NO | At present, this column is not supported and is NULL by default. |
| PCT_DIRECT_ACCESS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| ITYP_OWNER | VARCHAR2(128) | NO | At present, this column is not supported and is NULL by default. |
| ITYP_NAME | VARCHAR2(128) | NO | At present, this column is not supported and is NULL by default. |
| PARAMETERS | VARCHAR2(1000) | NO | At present, this column is not supported and is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| DOMIDX_STATUS | VARCHAR2(12) | NO | At present, this column is not supported and is NULL by default. |
| DOMIDX_OPSTATUS | VARCHAR2(6) | NO | At present, this column is not supported and is NULL by default. |
| FUNCIDX_STATUS | VARCHAR2(8) | NO | The status of a function-based index. |
| JOIN_INDEX | VARCHAR2(3) | NO | Indicates whether the index is a join index. |
| IOT_REDUNDANT_PKEY_ELIM | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| DROPPED | VARCHAR2(3) | NO | Indicates whether the index has been dropped and moved to the recycle bin. |
| VISIBILITY | VARCHAR2(9) | NO | Indicates whether the index is visible to the optimizer. |
| DOMIDX_MANAGEMENT | VARCHAR2(14) | NO | At present, this column is not supported and is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| ORPHANED_ENTRIES | VARCHAR2(3) | NO | Indicates whether the global index partition contains obsolete entries because index maintenance is delayed by the DROP/TRUNCATE PARTITION or MODIFY PARTITION INDEXING OFF operation. Valid values:YES: The index partition contains orphaned entries.NO: The index partition does not contain orphaned entries. |
| INDEXING | VARCHAR2(7) | NO | Indicates whether the global index is separated from the base table. Valid values:PARTIAL: The index is partial and follows the index attribute of the table.FULL: The index contains all partitions of the table. |
| AUTO | VARCHAR2(3) | NO | Indicates whether the index is an automatic index. Valid values: |