gle leaf block tend to point to rows in the same data blocks. If the value is near the number of rows, then the table is very randomly ordered. In this case, it is unlikely that index entries in the same leaf block point to rows in the same data blocks.
For bitmap indexes, this column is not applicable and is not used.
| STATUS |
VARCHAR2(8) |
|
Indicates whether a nonpartitioned index is VALID or UNUSABLE（对于分区索引，可以查看各个all_ind_partitions） |
| NUM_ROWS |
NUMBER |
|
Number of rows in the index |
| SAMPLE_SIZE |
NUMBER |
|
Size of the sample used to analyze the index |
| LAST_ANALYZED |
DATE |
|
Date on which this index was most recently analyzed |
| DEGREE |
VARCHAR2(40) |
|
Number of threads per instance for scanning the index, or DEFAULT |
| INSTANCES |
VARCHAR2(40) |
|
Number of instances across which the indexes to be scanned, or DEFAULT |
| PARTITIONED |
VARCHAR2(3) |
|
Indicates whether the index is partitioned (YES) or not (NO) |
| TEMPORARY |
VARCHAR2(1) |
|
Indicates whether the index is on a temporary table (Y) or not (N) |
| GENERATED |
VARCHAR2(1) |
|
Indicates whether the name of the index is system-generated (Y) or not (N) |
| SECONDARY |
VARCHAR2(1) |
|
Indicates whether the index is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N) |
| BUFFER_POOL |
VARCHAR2(7) |
|
Buffer pool to be used for index blocks: DEFAULT KEEP RECYCLE NULL |
| FLASH_CACHE |
VARCHAR2(7) |
|
Database Smart Flash Cache hint to be used for index blocks: DEFAULT KEEP NONE Solaris and Oracle Linux functionality only. |
| CELL_FLASH_CACHE |
VARCHAR2(7) |
|
Cell flash cache hint to be used for index blocks: DEFAULT KEEP NONE See Also: Oracle Exadata Storage Server Software documentation for more information
|
| USER_STATS |
VARCHAR2(3) |
|
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
| DURATION |
VARCHAR2(15) |
|
Indicates the duration of a temporary table: SYS$SESSION - Rows are preserved for the duration of the session SYS$TRANSACTION - Rows are deleted after COMMIT NNUL - Permanent table |
| PCT_DIRECT_ACCESS |
NUMBER |
|
For a secondary index on an index-organized table, the percentage of rows with VALID guess（对于无效值较多的索引，可以使用alter index i2 update block references来更新索引结构） |
| ITYP_OWNER |
VARCHAR2(30) |
|
For a domain index, the owner of the indextype |
| ITYP_NAME |
VARCHAR2(30) |
|
For a domain index, the name of the indextype |
| PARAMETERS |
VARCHAR2(1000) |
|
For a domain index, the parameter string |
| GLOBAL_STATS |
VARCHAR2(3) |
|
For partitioned indexes, indicates whether statistics were collected by analyzing the index as a whole (YES) or were estimated from statistics on underlying index partitions and subpartitions (NO)（当使用analyze时，oracle会统计分区或者子分区的统计信息，然后依据这些信息计算出分区或者全局的统计信息，因此其结构有时是不正确的,此时取值为NO；DBMS_STATS则会直接统计全局的统计信息，此时取值为YES） |
| DOMIDX_STATUS |
VARCHAR2(12) |
|
Status of a domain index: NULL - Index is not a domain index VALID - Index is a valid domain index IDXTYP_INVLD - Indextype of the domain index is invalid |
| DOMIDX_OPSTATUS |
VARCHAR2(6) |
|
Status of the operation on a domain index: NULL - Index is not a domain index VALID - Operation performed without errors FAILED - Operation failed with an error |
| FUNCIDX_STATUS |
VARCHAR2(8) |
|
Status of a function-based index: NULL - Index is not a function-based index ENABLED - Function-based index is enabled DISABLED - Function-based index is disabled |
| JOIN_INDEX |
VARCHAR2(3) |
|
Indicates whether the index is a join index (YES) or not (NO) |
| IOT_REDUN
|