Re: Bulk insert/delete

Thank you Vladimir ,
The logic behind this: the table1 has 80-200 mil or rows, and it has 10 different categories. clean up should process these categories in different way.,i.e data should be sum,avg,max etc inside the given category in the certain data ranges.These set of data should be kept.The avarage amount of data to keep around 2-5 mil rows. And COMMIT should happened only when category is done and then will proceed to next, so on and so on Received on Wed May 31 2006 - 07:05:25 CDT