Keyword: INDEX
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| ALL_INDEXES | Descriptions of indexes on tables accessible to the user |
| ALL_IND_COLUMNS | COLUMNs comprising INDEXes on accessible TABLES |
| ALL_IND_EXPRESSIONS | FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES |
| ALL_IND_PARTITIONS | |
| ALL_IND_SUBPARTITIONS | |
| ALL_JOIN_IND_COLUMNS | Join Index columns comprising the join conditions |
| ALL_PART_INDEXES | |
| DBA_INDEXES | Description for all indexes in the database |
| DBA_IND_COLUMNS | COLUMNs comprising INDEXes on all TABLEs and CLUSTERs |
| DBA_IND_EXPRESSIONS | FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS |
| DBA_IND_PARTITIONS | |
| DBA_IND_SUBPARTITIONS | |
| DBA_JOIN_IND_COLUMNS | Join Index columns comprising the join conditions |
| DBA_PART_INDEXES | |
| IND | Synonym for USER_INDEXES |
| INDEX_HISTOGRAM | statistics on keys with repeat count |
| INDEX_STATS | statistics on the b-tree |
| USER_INDEXES | Description of the user's own indexes |
| USER_IND_COLUMNS | COLUMNs comprising user's INDEXes and INDEXes on user's TABLES |
| USER_IND_EXPRESSIONS | Functional index expressions in user's indexes and indexes on user's tables |
| USER_IND_PARTITIONS | |
| USER_IND_SUBPARTITIONS | |
| USER_JOIN_IND_COLUMNS | Join Index columns comprising the join conditions |
| USER_PART_INDEXES |
Columns
| Column Name | Description |
|---|---|
| CHILD_IDX (V$MAP_SUBELEMENT) | |
| CHILD_IDX (GV$MAP_SUBELEMENT) | |
| CHUNK_INDEX (V$LOGMNR_TRANSACTION) | |
| CHUNK_INDEX (GV$LOGMNR_TRANSACTION) | |
| CLASS_INDEX (ALL_JAVA_DERIVATIONS) | index of the derived java class object |
| CLASS_INDEX (DBA_JAVA_DERIVATIONS) | index of the derived java class object |
| CLASS_INDEX (USER_JAVA_DERIVATIONS) | index of the derived java class object |
| CONF_INDX (GV$DISPATCHER) | |
| CONF_INDX (V$DISPATCHER) | |
| ELEM_IDX (V$MAP_EXT_ELEMENT) | |
| ELEM_IDX (V$MAP_ELEMENT) | |
| ELEM_IDX (GV$MAP_ELEMENT) | |
| ELEM_IDX (GV$MAP_EXT_ELEMENT) | |
| ELEM_IDX (GV$MAP_FILE_IO_STACK) | |
| ELEM_IDX (V$MAP_FILE_EXTENT) | |
| ELEM_IDX (GV$MAP_COMP_LIST) | |
| ELEM_IDX (GV$MAP_FILE_EXTENT) | |
| ELEM_IDX (V$MAP_FILE_IO_STACK) | |
| ELEM_IDX (V$MAP_COMP_LIST) | |
| EXCEPTION_INDEX (DBA_JAVA_THROWS) | the index of the exception |
| EXCEPTION_INDEX (ALL_JAVA_THROWS) | the index of the exception |
| EXCEPTION_INDEX (USER_JAVA_THROWS) | the index of the exception |
| FIELD_INDEX (USER_JAVA_FIELDS) | the index of the field |
| FIELD_INDEX (DBA_JAVA_FIELDS) | the index of the field |
| FIELD_INDEX (ALL_JAVA_FIELDS) | the index of the field |
| FILE_MAP_IDX (V$MAP_FILE_EXTENT) | |
| FILE_MAP_IDX (GV$MAP_FILE_EXTENT) | |
| FILE_MAP_IDX (GV$MAP_FILE) | |
| FILE_MAP_IDX (V$MAP_FILE) | |
| FILE_MAP_IDX (V$MAP_FILE_IO_STACK) | |
| FILE_MAP_IDX (GV$MAP_FILE_IO_STACK) | |
| FIRST_INDEX (V$CONTROLFILE_RECORD_SECTION) | |
| FIRST_INDEX (GV$CONTROLFILE_RECORD_SECTION) | |
| IND (DBA_OBJ_AUDIT_OPTS) | Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| IND (ALL_DEF_AUDIT_OPTS) | Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| IND (USER_OBJ_AUDIT_OPTS) | Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| INDEX_NAME (USER_SECONDARY_OBJECTS) | Name of the domain index |
| INDEX_NAME (USER_IND_PARTITIONS) | |
| INDEX_NAME (DBA_JOIN_IND_COLUMNS) | Index name |
| INDEX_NAME (USER_IND_SUBPARTITIONS) | |
| INDEX_NAME (DBA_IND_PARTITIONS) | |
| INDEX_NAME (DBA_INDEXES) | Name of the index |
| INDEX_NAME (USER_INDEXES) | Name of the index |
| INDEX_NAME (ALL_IND_COLUMNS) | Index name |
| INDEX_NAME (ALL_INDEXES) | Name of the index |
| INDEX_NAME (ALL_JOIN_IND_COLUMNS) | Index name |
| INDEX_NAME (USER_IND_COLUMNS) | Index name |
| INDEX_NAME (ALL_IND_PARTITIONS) | |
| INDEX_NAME (ALL_IND_SUBPARTITIONS) | |
| INDEX_NAME (ALL_IND_EXPRESSIONS) | Index name |
| INDEX_NAME (USER_IND_EXPRESSIONS) | Index name |
| INDEX_NAME (DBA_IND_EXPRESSIONS) | Index name |
| INDEX_NAME (DBA_LOBS) | Name of the LOB index |
| INDEX_NAME (USER_PART_INDEXES) | |
| INDEX_NAME (USER_LOBS) | Name of the LOB index |
| INDEX_NAME (DBA_PART_INDEXES) | |
| INDEX_NAME (DBA_IND_COLUMNS) | Index name |
| INDEX_NAME (ALL_LOBS) | Name of the LOB index |
| INDEX_NAME (USER_CONSTRAINTS) | The index used by the constraint |
| INDEX_NAME (DBA_CONSTRAINTS) | The index used by this constraint |
| INDEX_NAME (USER_JOIN_IND_COLUMNS) | Index name |
| INDEX_NAME (ALL_CONSTRAINTS) | The index used by this constraint |
| INDEX_NAME (ALL_SECONDARY_OBJECTS) | Name of the domain index |
| INDEX_NAME (ALL_PART_INDEXES) | |
| INDEX_NAME (IND) | Name of the index |
| INDEX_NAME (DBA_IND_SUBPARTITIONS) | |
| INDEX_NAME (DBA_SECONDARY_OBJECTS) | Name of the domain index |
| INDEX_NUMBER (V$INDEXED_FIXED_COLUMN) | |
| INDEX_NUMBER (GV$INDEXED_FIXED_COLUMN) | |
| INDEX_OWNER (ALL_IND_EXPRESSIONS) | Index owner |
| INDEX_OWNER (DBA_SECONDARY_OBJECTS) | Name of the domain index owner |
| INDEX_OWNER (ALL_IND_COLUMNS) | Index owner |
| INDEX_OWNER (DBA_IND_SUBPARTITIONS) | |
| INDEX_OWNER (USER_CONSTRAINTS) | The owner of the index used by the constraint |
| INDEX_OWNER (DBA_CONSTRAINTS) | The owner of the index used by this constraint |
| INDEX_OWNER (DBA_JOIN_IND_COLUMNS) | Index owner |
| INDEX_OWNER (ALL_CONSTRAINTS) | The owner of the index used by this constraint |
| INDEX_OWNER (DBA_IND_PARTITIONS) | |
| INDEX_OWNER (DBA_IND_COLUMNS) | Index owner |
| INDEX_OWNER (DBA_IND_EXPRESSIONS) | Index owner |
| INDEX_OWNER (ALL_SECONDARY_OBJECTS) | Name of the domain index owner |
| INDEX_OWNER (USER_SECONDARY_OBJECTS) | Name of the domain index owner |
| INDEX_OWNER (ALL_IND_PARTITIONS) | |
| INDEX_OWNER (ALL_IND_SUBPARTITIONS) | |
| INDEX_OWNER (ALL_JOIN_IND_COLUMNS) | Index owner |
| INDEX_TYPE (ALL_INDEXES) | |
| INDEX_TYPE (USER_INDEXES) | |
| INDEX_TYPE (DBA_INDEXES) | |
| INDEX_TYPE (IND) | |
| INDX (X$KSPPSV) | |
| INDX (V$ROWCACHE_SUBORDINATE) | |
| INDX (GV$ROWCACHE_SUBORDINATE) | |
| INDX (X$KSPPI) | |
| INDX (V$LOCK_ELEMENT) | |
| INDX (GV$GC_ELEMENT) | |
| INDX (X$KCBFWAIT) | |
| INDX (GV$ROWCACHE_PARENT) | |
| INDX (V$ROWCACHE_PARENT) | |
| INDX (V$GC_ELEMENT) | |
| INDX (X$KSLLT) | |
| INDX (X$KSQST) | |
| INDX (GV$LOCK_ELEMENT) | |
| INNER_INDEX (ALL_JAVA_INNERS) | index of the refered inner class |
| INNER_INDEX (DBA_JAVA_INNERS) | index of the refered inner class |
| INNER_INDEX (USER_JAVA_INNERS) | index of the refered inner class |
| INTERFACE_INDEX (USER_JAVA_IMPLEMENTS) | index of the interfaces implemented by the stored java class |
| INTERFACE_INDEX (DBA_JAVA_IMPLEMENTS) | index of the interfaces implemented by the stored java class |
| INTERFACE_INDEX (ALL_JAVA_IMPLEMENTS) | index of the interfaces implemented by the stored java class |
| JOIN_INDEX (ALL_INDEXES) | Is this index a join index? |
| JOIN_INDEX (IND) | Is this index a join index? |
| JOIN_INDEX (USER_INDEXES) | Is this index a join index? |
| JOIN_INDEX (DBA_INDEXES) | Is this index a join index? |
| LAST_INDEX (GV$CONTROLFILE_RECORD_SECTION) | |
| LAST_INDEX (V$CONTROLFILE_RECORD_SECTION) | |
| LIB_IDX (GV$MAP_ELEMENT) | |
| LIB_IDX (GV$MAP_LIBRARY) | |
| LIB_IDX (V$MAP_FILE) | |
| LIB_IDX (GV$MAP_FILE) | |
| LIB_IDX (V$MAP_ELEMENT) | |
| LIB_IDX (V$MAP_LIBRARY) | |
| LOB_INDEX_NAME (ALL_PART_LOBS) | |
| LOB_INDEX_NAME (USER_PART_LOBS) | |
| LOB_INDEX_NAME (DBA_PART_LOBS) | |
| METHOD_INDEX (USER_JAVA_THROWS) | the index of throwing method of the exception |
| METHOD_INDEX (DBA_JAVA_ARGUMENTS) | the index of hosting method of the argument |
| METHOD_INDEX (ALL_JAVA_METHODS) | the index of the method |
| METHOD_INDEX (DBA_JAVA_THROWS) | the index of throwing method of the exception |
| METHOD_INDEX (USER_JAVA_ARGUMENTS) | the index of hosting method of the argument |
| METHOD_INDEX (DBA_JAVA_METHODS) | the index of the method |
| METHOD_INDEX (ALL_JAVA_ARGUMENTS) | the index of hosting method of the argument |
| METHOD_INDEX (USER_JAVA_METHODS) | the index of the method |
| METHOD_INDEX (ALL_JAVA_THROWS) | the index of throwing method of the exception |
| PARENT_IDX (V$MAP_SUBELEMENT) | |
| PARENT_IDX (GV$MAP_SUBELEMENT) | |
| RESOURCE_INDEX (ALL_JAVA_DERIVATIONS) | index of the derived java resource object |
| RESOURCE_INDEX (USER_JAVA_DERIVATIONS) | index of the derived java resource object |
| RESOURCE_INDEX (DBA_JAVA_DERIVATIONS) | index of the derived java resource object |
| TERM_INDEX (USER_JAVA_RESOLVERS) | index of the resolver term in this row |
| TERM_INDEX (ALL_JAVA_RESOLVERS) | index of the resolver term in this row |
| TERM_INDEX (DBA_JAVA_RESOLVERS) | index of the resolver term in this row |
| USE_NO_INDEX (USER_MVIEWS) | Indicates whether the MV uses no index |
| USE_NO_INDEX (ALL_MVIEWS) | Indicates whether the MV uses no index |
| USE_NO_INDEX (DBA_MVIEWS) | Indicates whether the MV uses no index |