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,