About
Statistics on Index stored in the data dictionary :
- DBA_INDEXES
- DBA_IND_STATISTICS
Articles Related
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 |