I am trying to figure out the fastest way to move rows from a current
table to a history table. There are currently 150,000 rows of which
about 60,000 get moved (monthly). There are multiple queries involved to
figure out whether or not a row should be moved, so I am making multiple
passes over
Meant this to go to whole list , sorry for duplicate
Begin forwarded message:
On Dec 29, 2004, at 4:58 PM, Dave Smith wrote:
I am trying to figure out the fastest way to move rows from a current
table to a history table. There are currently 150,000 rows of which
about 60,000 get moved (monthly).
