Feature
DBA_INDEXES 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 MySQL mode.
Related views
USER_INDEXESALL_INDEXES
Fields
| Field | 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 field 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 field is not supported and is NULL by default. |
| MAX_TRANS | NUMBER | NO | The maximum number of transactions. At present, this field is not supported and is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | The size of the initial extent. At present, this field is not supported and is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | The size of secondary extents. At present, this field is not supported and is NULL by default. |
| MIN_EXTENTS | NUMBER | NO | The minimum number of extents allowed in the segment. At present, this field is not supported and is NULL by default. |
| MAX_EXTENTS | NUMBER | NO | The maximum number of extents allowed in the segment. At present, this field is not supported and is NULL by default. |
| PCT_INCREASE | NUMBER | NO | The percentage increase in extent size. At present, this field is not supported and is NULL by default. |
| PCT_THRESHOLD | NUMBER | NO | The percentage of block space allowed for each index. At present, this field 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 field is not supported and is NULL by default. |
| FREELISTS | NUMBER | NO | The number of process freelists allocated to each segment. At present, this field is not supported and is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | The number of freelist groups allocated to each segment. At present, this field is not supported and is NULL by default. |
| PCT_FREE | NUMBER | NO | The minimum percentage of free space in a block. At present, this field 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 field is not supported and is NULL by default. |
| BLEVEL | NUMBER | NO | The B*-tree level. At present, this field is not supported and is NULL by default. |
| LEAF_BLOCKS | NUMBER | NO | The number of leaf blocks in the index. At present, this field is not supported and is NULL by default. |
| DISTINCT_KEYS | NUMBER | NO | The number of distinct indexed values. At present, this field is not supported and is NULL by default. |
| AVG_LEAF_BLOCKS_PER_KEY | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| AVG_DATA_BLOCKS_PER_KEY | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| CLUSTERING_FACTOR | NUMBER | NO | At present, this field 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 field is not supported and is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| LAST_ANALYZED | DATE | NO | At present, this field is not supported and is NULL by default. |
| DEGREE | VARCHAR2(40) | NO | At present, this field is not supported and is NULL by default. |
| INSTANCES | VARCHAR2(40) | NO | At present, this field 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 field is not supported and is NULL by default. |
| GENERATED | VARCHAR2(1) | NO | At present, this field is not supported and is NULL by default. |
| SECONDARY | VARCHAR2(1) | NO | At present, this field is not supported and is NULL by default. |
| BUFFER_POOL | VARCHAR2(7) | NO | At present, this field is not supported and is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | At present, this field is not supported and is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this field is not supported and is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | At present, this field is not supported and is NULL by default. |
| DURATION | VARCHAR2(15) | NO | At present, this field is not supported and is NULL by default. |
| PCT_DIRECT_ACCESS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| ITYP_OWNER | VARCHAR2(128) | NO | At present, this field is not supported and is NULL by default. |
| ITYP_NAME | VARCHAR2(128) | NO | At present, this field is not supported and is NULL by default. |
| PARAMETERS | VARCHAR2(1000) | NO | At present, this field is not supported and is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | At present, this field is not supported and is NULL by default. |
| DOMIDX_STATUS | VARCHAR2(12) | NO | At present, this field is not supported and is NULL by default. |
| DOMIDX_OPSTATUS | VARCHAR2(6) | NO | At present, this field 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 field 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 field is not supported and is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | At present, this field 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: |
| INDEXING | VARCHAR2(7) | NO | Indicates whether the global index is separated from the base table. Valid values: |
| AUTO | VARCHAR2(3) | NO | Indicates whether the index is an automatic index. Valid values: |