Saturday, January 16th, 2010
Oracle Delete Taking a Long Time
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.
Bookmark to:
Bookmark to:
