Keyword: KEY
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| ALL_APPLY_KEY_COLUMNS | Alternative key columns for a STREAMS table visible to the current user |
| ALL_DIM_JOIN_KEY | Representation of a join between two dimension tables. |
| ALL_DIM_LEVEL_KEY | Representations of columns of a dimension level |
| ALL_MVIEW_KEYS | Description of the columns that appear in the GROUP BY list of a materialized view accessible to the user |
| ALL_PART_KEY_COLUMNS | |
| ALL_SUBPART_KEY_COLUMNS | |
| ALL_SUMMARY_KEYS | |
| DBA_APPLY_KEY_COLUMNS | alternative key columns for a table for STREAMS |
| DBA_DIM_JOIN_KEY | Representation of a join between two dimension tables. |
| DBA_DIM_LEVEL_KEY | Representations of columns of a dimension level |
| DBA_MVIEW_KEYS | Description of the columns that appear in the GROUP BY list of a materialized view accessible to dba |
| DBA_PART_KEY_COLUMNS | |
| DBA_SUBPART_KEY_COLUMNS | |
| DBA_SUMMARY_KEYS | |
| USER_DIM_JOIN_KEY | Representation of a join between two dimension tables. |
| USER_DIM_LEVEL_KEY | Representations of columns of a dimension level |
| USER_MVIEW_KEYS | Description of the columns that appear in the GROUP BY list of a materialized view created by the user |
| USER_PART_KEY_COLUMNS | |
| USER_SUBPART_KEY_COLUMNS | |
| USER_SUMMARY_KEYS |
Columns
| Column Name | Description |
|---|---|
| AVG_BLOCKS_PER_KEY (USER_CLUSTERS) | Average number of blocks containing rows with a given cluster key |
| AVG_BLOCKS_PER_KEY (ALL_CLUSTERS) | Average number of blocks containing rows with a given cluster key |
| AVG_BLOCKS_PER_KEY (CLU) | Average number of blocks containing rows with a given cluster key |
| AVG_BLOCKS_PER_KEY (DBA_CLUSTERS) | Average number of blocks containing rows with a given cluster key |
| AVG_DATA_BLOCKS_PER_KEY (USER_INDEXES) | The average number of data blocks per key |
| AVG_DATA_BLOCKS_PER_KEY (DBA_INDEXES) | The average number of data blocks per key |
| AVG_DATA_BLOCKS_PER_KEY (IND) | The average number of data blocks per key |
| AVG_DATA_BLOCKS_PER_KEY (DBA_IND_SUBPARTITIONS) | |
| AVG_DATA_BLOCKS_PER_KEY (ALL_IND_PARTITIONS) | |
| AVG_DATA_BLOCKS_PER_KEY (USER_IND_PARTITIONS) | |
| AVG_DATA_BLOCKS_PER_KEY (DBA_IND_PARTITIONS) | |
| AVG_DATA_BLOCKS_PER_KEY (ALL_INDEXES) | The average number of data blocks per key |
| AVG_DATA_BLOCKS_PER_KEY (ALL_IND_SUBPARTITIONS) | |
| AVG_DATA_BLOCKS_PER_KEY (USER_IND_SUBPARTITIONS) | |
| AVG_LEAF_BLOCKS_PER_KEY (ALL_INDEXES) | The average number of leaf blocks per key |
| AVG_LEAF_BLOCKS_PER_KEY (DBA_IND_SUBPARTITIONS) | |
| AVG_LEAF_BLOCKS_PER_KEY (DBA_INDEXES) | The average number of leaf blocks per key |
| AVG_LEAF_BLOCKS_PER_KEY (USER_IND_SUBPARTITIONS) | |
| AVG_LEAF_BLOCKS_PER_KEY (USER_INDEXES) | The average number of leaf blocks per key |
| AVG_LEAF_BLOCKS_PER_KEY (IND) | The average number of leaf blocks per key |
| AVG_LEAF_BLOCKS_PER_KEY (USER_IND_PARTITIONS) | |
| AVG_LEAF_BLOCKS_PER_KEY (ALL_IND_SUBPARTITIONS) | |
| AVG_LEAF_BLOCKS_PER_KEY (DBA_IND_PARTITIONS) | |
| AVG_LEAF_BLOCKS_PER_KEY (ALL_IND_PARTITIONS) | |
| DIM_KEY_ID (ALL_DIM_JOIN_KEY) | Join key ID (unique within a dimension) |
| DIM_KEY_ID (DBA_DIM_JOIN_KEY) | Join key ID (unique within a dimension) |
| DIM_KEY_ID (USER_DIM_JOIN_KEY) | Join key ID (unique within a dimension) |
| DISTINCT_KEYS (USER_INDEXES) | The number of distinct keys in the index |
| DISTINCT_KEYS (USER_IND_PARTITIONS) | |
| DISTINCT_KEYS (ALL_IND_SUBPARTITIONS) | |
| DISTINCT_KEYS (ALL_IND_PARTITIONS) | |
| DISTINCT_KEYS (DBA_IND_PARTITIONS) | |
| DISTINCT_KEYS (DBA_INDEXES) | The number of distinct keys in the index |
| DISTINCT_KEYS (ALL_INDEXES) | The number of distinct keys in the index |
| DISTINCT_KEYS (DBA_IND_SUBPARTITIONS) | |
| DISTINCT_KEYS (IND) | The number of distinct keys in the index |
| DISTINCT_KEYS (USER_IND_SUBPARTITIONS) | |
| JOIN_KEY_ID (ALL_DIM_CHILD_OF) | Keys that join child uniquely to the parent |
| JOIN_KEY_ID (DBA_DIM_CHILD_OF) | Keys that join child uniquely to the parent |
| JOIN_KEY_ID (USER_DIM_CHILD_OF) | Keys that join child uniquely to the parent |
| KEY (V$ROWCACHE_PARENT) | |
| KEY (GV$ROWCACHE_PARENT) | |
| KEY (GV$ROWCACHE_SUBORDINATE) | |
| KEY (V$ROWCACHE_SUBORDINATE) | |
| KEY_POSITION (ALL_DIM_LEVEL_KEY) | Ordinal position of the key column within the level |
| KEY_POSITION (DBA_DIM_LEVEL_KEY) | Ordinal position of the key column within the level |
| KEY_POSITION (ALL_DIM_JOIN_KEY) | Position of the key column within the level |
| KEY_POSITION (USER_DIM_JOIN_KEY) | Position of the key column within the level |
| KEY_POSITION (USER_DIM_LEVEL_KEY) | Ordinal position of the key column within the level |
| KEY_POSITION (DBA_DIM_JOIN_KEY) | Position of the key column within the level |
| KEY_SIZE (ALL_CLUSTERS) | Estimated size of cluster key plus associated rows |
| KEY_SIZE (CLU) | Estimated size of cluster key plus associated rows |
| KEY_SIZE (DBA_CLUSTERS) | Estimated size of cluster key plus associated rows |
| KEY_SIZE (USER_CLUSTERS) | Estimated size of cluster key plus associated rows |
| PARTITIONING_KEY_COUNT (ALL_PART_INDEXES) | |
| PARTITIONING_KEY_COUNT (USER_PART_TABLES) | |
| PARTITIONING_KEY_COUNT (DBA_PART_TABLES) | |
| PARTITIONING_KEY_COUNT (DBA_PART_INDEXES) | |
| PARTITIONING_KEY_COUNT (USER_PART_INDEXES) | |
| PARTITIONING_KEY_COUNT (ALL_PART_TABLES) | |
| PRIMARY_KEY (ALL_MVIEW_LOGS) | If YES, the materialized view log records primary key information |
| PRIMARY_KEY (USER_SNAPSHOT_LOGS) | If YES, the snapshot log records primary key information |
| PRIMARY_KEY (DBA_MVIEW_LOGS) | If YES, the materialized view log records primary key information |
| PRIMARY_KEY (DBA_SNAPSHOT_LOGS) | If YES, the snapshot log records primary key information |
| PRIMARY_KEY (ALL_SNAPSHOT_LOGS) | If YES, the snapshot log records primary key information |
| PRIMARY_KEY (USER_MVIEW_LOGS) | If YES, the materialized view log records primary key information |
| PRIMARY_KEY_VALUE (ALL_REPRESOLUTION_STATISTICS) | Primary key of the replicated row (character data) |
| PRIMARY_KEY_VALUE (USER_REPRESOLUTION_STATISTICS) | Primary key of the replicated row (character data) |
| PRIMARY_KEY_VALUE (DBA_REPRESOLUTION_STATISTICS) | Primary key of the replicated row (character data) |
| SUBPARTITIONING_KEY_COUNT (USER_PART_TABLES) | |
| SUBPARTITIONING_KEY_COUNT (ALL_PART_INDEXES) | |
| SUBPARTITIONING_KEY_COUNT (ALL_PART_TABLES) | |
| SUBPARTITIONING_KEY_COUNT (DBA_PART_INDEXES) | |
| SUBPARTITIONING_KEY_COUNT (USER_PART_INDEXES) | |
| SUBPARTITIONING_KEY_COUNT (DBA_PART_TABLES) |