Joined: 14 Oct 2005 Posts: 1191 Location: Bangalore,India
I have few questions:
First Do you wnat to delete all the rows of the table then run dummy load REPLACE?
Secondly You have specified that you want to delete little by little ...What does that mean & whats the business justification for this?
We have a table which is being loaded 24/7. Every day we take back up of the table in the evening and delete the rows for which we have back up. Mean while if any data is inserted the data is being deleted next day. In this process, when we delete data for more than 10 million rows it takes more time and there is a Lock on the table and the online systems are not able to update table creating chaos. Hope you understand the situation.