|
Posted by kumar on 11/09/95 11:31
we are trying to delete data from a huge 75 million records table
it takes 4hr to prune data
delete from Company where recordid in (select top 10000 recordid from
recordid_Fed3 where flag = 0)
we have a loop that prunes 10000 records at a time in a while loop
let me know if there is a better way to acheive this
Navigation:
[Reply to this message]
|