Oracle Database - Index Statistics

> Database > Oracle Database

1 - About

Statistics on Index stored in the data dictionary :

  • DBA_INDEXES
  • DBA_IND_STATISTICS
Advertising

3 - 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