Deleting a lot of rows fast

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

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

   1: ALTER TABLE table_name ACTIVATE NOT LOGGED INITIALLY; --disable logging

   2: DELETE FROM table_name WHERE ....;

   3: COMMIT; --Commits and enable logging

I really want to know what you think