Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rebuild indexes after masive delete improve the performance?

Hello, recently I have had to delete a huge number of rows in a 10 years used database. I did it in order to try to improve the performance of the program that works with this database. Once it is done, I noticed the access to the data is even slower than before, I know it is difficult to find out the reason but…..do i have to rebuild the indexes of these tables?????. I dont mean in order to save space, but for the performance.

Thanks!!!!

Comments
Post Details
Added on Jan 16 2024
7 comments
1,483 views