INDEX_STATS

This view collects information from index statistics (after an ANALYZE INDEX).

Fields

The most relevant view fields are as follows:

• NAME: The name of the index

• HEIGHT: The height of the B-tree index

• BLOCKS: The number of allocated database blocks

• BTREE_SPACE: The total space allocated

• USED_SPACE: The total space used

• DISTINCT_KEYS: The number of distinct keys in the index

• OPT_CMPR_COUNT: The optimal key compression length

• OPT_CMPR_PCTSAVE: Space saving corresponding to the adoption of the optimal key compression length

See also

• The DBA_INDEXESsection in this appendix