I have a table with a large amount of data (380 million). I need to delete the old data that is no longer useful in the system. I'm generating the backup as a precaution.
What is the best way to delete it?
- Delete with a delete restricting from which date?
- Delete 50k by 50k?
- Delete 1k in 1k bit by bit?
- Or some other way?
I'm doing 50k in 50k but it's quite time consuming. What is the best solution for agility?