Purpose
The DBA_INDEXES view displays the indexes on all tables in the database.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
References
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 its value is NULL by default. |
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace containing the index. |
| INI_TRANS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_TRANS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MIN_EXTENTS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_EXTENTS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| PCT_INCREASE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| PCT_THRESHOLD | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| INCLUDE_COLUMN | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| FREELISTS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| PCT_FREE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| LOGGING | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| BLEVEL | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| LEAF_BLOCKS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| DISTINCT_KEYS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| AVG_LEAF_BLOCKS_PER_KEY | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| AVG_DATA_BLOCKS_PER_KEY | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| CLUSTERING_FACTOR | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| STATUS | VARCHAR2(8) | NO | Indicates whether the nonpartitioned index is valid or unusable. |
| NUM_ROWS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| LAST_ANALYZED | DATE | NO | At present, this column is not supported and its value is NULL by default. |
| DEGREE | VARCHAR2(40) | NO | At present, this column is not supported and its value is NULL by default. |
| INSTANCES | VARCHAR2(40) | NO | At present, this column is not supported and its value 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 its value is NULL by default. |
| GENERATED | VARCHAR2(1) | NO | At present, this column is not supported and its value is NULL by default. |
| SECONDARY | VARCHAR2(1) | NO | At present, this column is not supported and its value is NULL by default. |
| BUFFER_POOL | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| DURATION | VARCHAR2(15) | NO | At present, this column is not supported and its value is NULL by default. |
| PCT_DIRECT_ACCESS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| ITYP_OWNER | VARCHAR2(128) | NO | At present, this column is not supported and its value is NULL by default. |
| ITYP_NAME | VARCHAR2(128) | NO | At present, this column is not supported and its value is NULL by default. |
| PARAMETERS | VARCHAR2(1000) | NO | At present, this column is not supported and its value is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| DOMIDX_STATUS | VARCHAR2(12) | NO | At present, this column is not supported and its value is NULL by default. |
| DOMIDX_OPSTATUS | VARCHAR2(6) | NO | At present, this column is not supported and its value is NULL by default. |
| FUNCIDX_STATUS | VARCHAR2(8) | NO | The status of the 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 its value 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 its value is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| ORPHANED_ENTRIES | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| INDEXING | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| AUTO | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |