Oracle Database - Index Statistics

About

Statistics on Index stored in the data dictionary :

  • DBA_INDEXES
  • DBA_IND_STATISTICS

Default Index Values

Default Index Values When Statistics Are Missing

Index Statistic Default Value Used by Optimizer
Levels 1
Leaf blocks 25
Leaf blocks/key 1
Data blocks/key 1
Distinct keys 100
Clustering factor 800

Powered by ComboStrap