Query on indexes in oracle

[vinayhc]

Hi all,

i have doubt on indexes.

suppose we have an index on a table. assume there are 100000 rows in the table.
now we delete those 100000 rows and insert a new set of rows.

Will there be fragmentation in the index? And also will the index performance be same as before?

Thanks,
Vinay

[debasisdas]

Yes the index will be fragmented and yoiu need to rebuild the index.

[pande.dhiraj]

ya it work properly but after that it you have to rebuild that index so that the index will also the delete all the rows.

so rebuild that indexes