If you need to delete millions of rows and you're not careful, you can cause a database outage. Here is what you have to think about to solve this.
1.create partitioned table with the desired expiring criteria;2. Drop partitions as needed.
1.create partitioned table with the desired expiring criteria;2. Drop partitions as needed.