Hi,
We have a table which has more than 100 million rows (Oracle),we get a weekly file of around 30 million rows.Our requirement is to see if there are any rows from the file which exist in the table and delete them.Delete is done depending on the key columns.Which would be a better approach to do this.
I have tried reading the file and delete rows by selecting Write Method of Delete rows in Oracle Enterprise stage,but it is very slow.Is there a better way of deleting the records.
Thanks
best way to delete
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: