Query on indexes in oracle

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

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

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