I've got a table that has 4 million rows in it.
It has 2 columns an id and a description(long raw)
i'm trying to delete some rows where the id doesnt exist in another table and its fallen over after 9 hours after blowing the undo tablespace (8GB).
I presume that its due to the delete on the LONG RAW column on the table as the select come back in 20 seconds.
Any ideas on how to speed this up?