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 |