A.22 USER_INDEXES
USER_INDEXES
data dictionary for Oracle Database Gateway for DRDA.
The USER_INDEXES
view contains description of the user's indexes:
Column name | Description |
---|---|
|
Name of the index |
|
Type of 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 index-organized table |
|
Number of process freelists allocated to a segment |
|
Number of freelist groups allocated to a 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 and 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 indexes: |
|
Number of rows in the index |
|
Size of the sample used to analyze the index |
|
Date on which the 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