-
delete from long raw column
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?
thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|