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? |