Friday, February 18, 2011

index statistics in oracle


Statistics generated include the index statistics following:

Table statistics
Number of rows
Number of blocks
Average row length
Column statistics
Number of distinct values (NDV) in column 
Number of nulls in column 
Data distribution (histogram) Index statistics 
Number of leaf blocks 
Levels 
Clustering factor System statistics
I/O performance and utilization
CPU performance and utilization

Hope this Helps! Rupam