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

Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial