I have a set of rows in a partition that represents some cached data. I want to refresh that cache without any concern for what is already there. Is it possible to delete an entire partition without having to do any selects?
No, but you can delete an entire table with one call, so you might consider making your partitions separate tables instead. (But, of course, you can't do cross-table queries.)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With