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 |