Statistics on Index stored in the data dictionary :
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 |