Saturday, January 16th, 2010...10:16 pm

Oracle Delete Taking a Long Time

Jump to Comments

It may look like your delete statement is hung, but ff your table has foreign keys in another table without indexes on that column Oracle will full table scan that other table for every row that you’re deleting. Hopefully this saves someone some time.

Leave a Reply