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
Tags: DB2 · SQLNo Comments
Loading ...
Oracle PeopleTools Blog
0 responses so far ↓
There are no comments yet...Kick things off by filling out the form below.