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