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
db/oracle/index_statistic.txt · Last modified: 2017/09/06 19:30 by gerardnico