-
Junior Member
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
-
Re: Query on indexes in oracle
Yes the index will be fragmented and yoiu need to rebuild the index.
-
Junior Member
Re: Query on indexes in oracle
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules