How to (efficiently) delete millions of records in a SQL table
[Updated on 2024-06-30 based on feedback from comments]
A while ago, I blogged about how to efficiently update millions of records in a SQL table, today I’d like to show you a simple trick to do the same when deleting millions of records in a SQL table.
The idea