Table: USER_INDEXES
Description of the user's own indexes
Column Name | Description |
---|---|
AVG_DATA_BLOCKS_PER_KEY | The average number of data blocks per key |
AVG_LEAF_BLOCKS_PER_KEY | The average number of leaf blocks per key |
BLEVEL | B-Tree level |
BUFFER_POOL | The default buffer pool to be used for index blocks |
CLUSTERING_FACTOR | A measurement of the amount of (dis)order of the table this index is for |
COMPRESSION | Compression property of the index: "ENABLED", "DISABLED", or NULL |
DEGREE | The number of threads per instance for scanning the partitioned index |
DISTINCT_KEYS | The number of distinct keys in the index |
DOMIDX_OPSTATUS | Status of the operation on the domain index |
DOMIDX_STATUS | Is the indextype of the domain index valid |
DURATION | If index on temporary table, then duration is sys$session or sys$transaction else NULL |
FREELISTS | Number of process freelists allocated in this segment |
FREELIST_GROUPS | Number of freelist groups allocated to this segment |
FUNCIDX_STATUS | Is the Function-based Index DISABLED or ENABLED? |
GENERATED | Was the name of this index system generated? |
GLOBAL_STATS | Are the statistics calculated without merging underlying partitions? |
INCLUDE_COLUMN | User column-id for last column to be included in index-only table top index |
INDEX_NAME | Name of the index |
INDEX_TYPE | |
INITIAL_EXTENT | Size of the initial extent in bytes |
INI_TRANS | Initial number of transactions |
INSTANCES | The number of instances across which the partitioned index is to be scanned |
ITYP_NAME | If domain index, then this is the name of the associated indextype |
ITYP_OWNER | If domain index, then this is the indextype owner |
JOIN_INDEX | Is this index a join index? |
LAST_ANALYZED | The date of the most recent time this index was analyzed |
LEAF_BLOCKS | The number of leaf blocks in the index |
LOGGING | Logging attribute |
MAX_EXTENTS | Maximum number of extents allowed in the segment |
MAX_TRANS | Maximum number of transactions |
MIN_EXTENTS | Minimum number of extents allowed in the segment |
NEXT_EXTENT | Size of secondary extents in bytes |
NUM_ROWS | Number of rows in the index |
PARAMETERS | If domain index, then this is the parameter string |
PARTITIONED | Is this index partitioned? YES or NO |
PCT_DIRECT_ACCESS | If index on IOT, then this is percentage of rows with Valid guess |
PCT_FREE | Minimum percentage of free space in a block |
PCT_INCREASE | Percentage increase in extent size |
PCT_THRESHOLD | Threshold percentage of block space allowed per index entry |
PREFIX_LENGTH | Number of key columns in the prefix used for compression |
SAMPLE_SIZE | The sample size used in analyzing this index |
SECONDARY | Is the index object created as part of icreate for domain indexes? |
STATUS | Whether the non-partitioned index is in USABLE or not |
TABLESPACE_NAME | Name of the tablespace containing the index |
TABLE_NAME | Name of the indexed object |
TABLE_OWNER | Owner of the indexed object |
TABLE_TYPE | Type of the indexed object |
TEMPORARY | Can the current session only see data that it place in this object itself? |
UNIQUENESS | Uniqueness status of the index: "UNIQUE", "NONUNIQUE", or "BITMAP" |
USER_STATS | Were the statistics entered directly by the user? |