Forum Stats

  • 3,839,949 Users
  • 2,262,551 Discussions


Mass Deletes on a table when TRUNCATE option is not available

Mark Warner
Mark Warner Member Posts: 5 Red Ribbon

I have a table where a procedure create about 450million orphan rows out of the 600million row which are there. I've been trying to delete them in 10,000 row chunks to keep the stress on the undo space down, but its taking for ever (The delete is based upon a join on the table to help determine which rows are orphaned). Is this the best/easiest/most expediate way to accomplish this, or is there option that anyone can think of....? Thanks in advanced...