Hi,
I have table with 1182039 rows.
I created an index on this table on column xyz. After that I analyzed the index. It shows foll. values in DBA_INDEX for that index. New Index size is 15368192 from dba_segments.
xyz is a varchar2(150).
BLEVEL: 2
LEAF_BLOCKS: 1823
DISTINCT_KEYS: 16669
AVG_LEAF_BLOCKS_PER_KEY: 1
AVG_DATA_BLOCKS_PER_KEY: 12
CLUSTERING_FACTOR: 202428
NUM_ROWS: 477284
What is the significance of each of these values?
and How do I decide the INITIAL and NEXT extents values from these?
Thanks,
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart