Oracle Database Discussions

Hi All,

I would like to know whether index is fragmented or not.

Table has 4 columns and primary key is defined on all 4 columns. We inserted around 30 M records and before that

we calculated space to be added for table and index tablespace. Space usage was proper for Table segment but it

was observed that index segment was grown exponetially than expected.


If table segment is fragmented means index also fragmented and rebuild it or is it possible that only index can be fragmeneted (looks silly as when any change in table,there is change in index).

Insertion was done in insert command so that even though there is HWM limit, records could be inserted in free space below HWM but index segment grows as records rowid will be inserted .
I think i have confused all ........... :-(

My bottom line is how to find out only index is fragmented or not

Thanks & Regards