Table of Contents

Oracle Database - Index Statistics

About

Statistics on Index stored in the data dictionary :

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