I'm doing a huge task of deleting data in a large table of 300 million rows.
This table contains 5 Foreign Keys.
I tried a first test that gave me catastrophic results.
- Do you have any performance tips to perform this task?
In addition, I want to remove these foreign keys.
Do you think it is more efficient to disable/enable or drop/recreate?