Deleting a lot of rows fast

Mar 192008

Need to delete millions of rows from a table fast? Here is how you can do this:

ALTER TABLE table_name ACTIVATE NOT LOGGED INITIALLY; --disable logging
DELETE FROM table_name WHERE ....;
COMMIT; --Commits and enable logging

WorkingScripts