I am running this query:
DELETE FROM tab;
It's been running since 2PM yesterday. Can you make it go faster?
You shouldn't delete 80M rows in a single transaction. You should have used TRUNCATE instead of DELETE. I have killed your session and it will be a while before it completes.
Developer (5 minutes later):
I tried TRUNCATE but it says my table is locked.
I know, the table will be locked up for a while while the transaction rolls back.
Can you make it go faster?
I have turned on _transmogrify_delete_queries on so that is the best I can do.
Thanks!! That should definitely help!!!