A.5 ALL_INDEXES
ALL_INDEXES
data dictionary for Oracle Database Gateway for DRDA.
The ALL_INDEXES
view contains description of indexes on tables accessible to the user.
Column name | Description |
---|---|
|
Owner of the index |
|
Name of the index |
|
Type of the index |
|
Owner of the indexed object |
|
Name of the indexed object |
|
Type of the indexed object |
|
Uniqueness status of the index |
|
N/A |
|
0 |
|
Name of the tablespace containing the index |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
Threshold percentage of block space allowed per index entry |
|
Column ID of the last column to be included in an index-organized table |
|
Number of process freelists allocated to this segment |
|
Number of freelist groups allocated to this segment |
|
N/A |
|
Logging information |
|
Depth of the index from its root block to its leaf blocks. A depth of 1 indicates that the root block and the leaf block are the same. |
|
Number of leaf blocks in the index |
|
Number of distinct indexed values. For indexes that enforce |
|
N/A |
|
N/A |
|
N/A |
|
State of the index: |
|
Number of rows in the index |
|
Size of the sample used to analyze the index |
|
Date on which an index was most recently analyzed |
|
Number of threads per instance for scanning the index |
|
Number of instances across which the index is to be scanned |
|
Whether the index is partitioned |
|
Whether the index is on a temporary table |
|
Whether the name of the index is system generated |
|
N/A |
|
Whether the index is a secondary object |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
|
N/A |
Parent topic: Oracle DB2 Data Dictionary Views