2.178 ALL_INDEXES
ALL_INDEXES
describes the indexes on the tables accessible to the current user. To gather statistics for this view and the related views DBA_INDEXES
and USER_INDEXES
, use the DBMS_STATS
package.
Related Views
-
DBA_INDEXES
describes all indexes in the database. -
USER_INDEXES
describes the indexes owned by the current user. This view does not display theOWNER
column.
Note:
Column names followed by an asterisk are populated only if you collect statistics on the index using the DBMS_STATS
package.
Column | Datatype | NULL | 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:
|
|
|
|
Indicates whether the index is unique ( |
|
|
|
The type of compression being used for the index:
|
|
|
|
Number of columns in the prefix of the compression key |
|
|
|
Name of the tablespace containing the index |
|
|
|
Initial number of transactions |
|
|
|
Maximum number of transactions |
|
|
|
Size of the initial extent |
|
|
|
Size of secondary extents |
|
|
|
Minimum number of extents allowed in the segment |
|
|
|
Maximum number of extents allowed in the segment |
|
|
|
Percentage increase in extent size |
|
|
|
Threshold percentage of block space allowed per index entry |
|
|
|
Column ID of the last column to be included in index-organized table primary key (non-overflow) index. This column maps to the |
|
|
|
Number of process freelists allocated to this segment |
|
|
|
Number of freelist groups allocated to this segment |
|
|
|
Minimum percentage of free space in a block |
|
|
|
Indicates whether or not changes to the index are logged:
|
|
|
|
B*-Tree level (depth of the index from its root block to its leaf blocks). A depth of |
|
|
|
Number of leaf blocks in the index |
|
|
|
Number of distinct indexed values. For indexes that enforce |
|
|
|
Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer. For indexes that enforce |
|
|
|
Average number of data blocks in the table that are pointed to by a distinct value in the index rounded to the nearest integer. This statistic is the average number of data blocks that contain rows that contain a given value for the indexed columns. |
|
|
|
Indicates the amount of order of the rows in the table based on the values of the index.
For bitmap indexes, this column is not applicable. |
|
|
|
Indicates whether a nonpartitioned index is |
|
|
|
Number of rows in the index. For bitmap indexes, this column is the number of distinct keys, so its value is the same as the |
|
|
|
Size of the sample used to analyze the index |
|
|
|
Date on which this index was most recently analyzed |
|
|
|
Number of threads per instance for scanning the index, or |
|
|
|
Number of instances across which the indexes to be scanned, or |
|
|
|
Indicates whether the index is partitioned ( |
|
|
|
Indicates whether the index is on a temporary table ( |
|
|
|
Indicates whether the name of the index is system-generated ( |
|
|
|
Indicates whether the index is a secondary object created by the |
|
|
|
Buffer pool to be used for index blocks:
|
|
|
|
Database Smart Flash Cache hint to be used for index blocks:
Solaris and Oracle Linux functionality only. |
|
|
|
Cell flash cache hint to be used for index blocks:
See Also: Oracle Exadata Storage Server Software documentation for more information |
|
|
|
Indicates whether statistics were entered directly by the user ( |
|
|
|
Indicates the duration of a temporary table:
NULL - Permanent table |
|
|
|
For a secondary index on an index-organized table, the percentage of rows with |
|
|
|
For a domain index, the owner of the indextype |
|
|
|
For a domain index, the name of the indextype |
|
|
|
For a domain index, the parameter string |
|
|
|
|
|
|
|
Status of a domain index:
|
|
|
|
Status of the operation on a domain index:
|
|
|
|
Status of a function-based index:
|
|
|
|
Indicates whether the index is a join index ( |
|
|
|
Indicates whether redundant primary key columns are eliminated from secondary indexes on index-organized tables ( |
|
|
|
Indicates whether the index has been dropped and is in the recycle bin ( This view does not return the names of indexes that have been dropped. |
|
|
|
Indicates whether the index is |
|
|
|
If this is a domain index, indicates whether the domain index is system-managed ( |
|
|
|
Indicates whether the index segment has been created ( |
|
|
|
Indicates whether a global index contains stale entries because of deferred index maintenance during Possible values:
|
|
|
|
Indicates whether a global index is decoupled from the underlying table. Possible values:
|
|
|
Indicates whether the index is an auto index ( |
Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1.
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_STATS
package