Skip to Main Content

SQL & PL/SQL

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!

oracle drop vs truncate partition performance

user650888Mar 8 2024

I have some tables with data from 2014, partitioned monthly

The application is running slow because of this, assuming all the backups are there etc I have a question about dropping vs truncating partitions

which is best in terms of performance of the application so that the selects / inserts speeds up , after dropping or truncating older partitions, we want to use the server resources for best performance

Comments
Post Details
Added on Mar 8 2024
15 comments
8,212 views