Archiving Large Tables

Hi

I have a few tables in my db which are 2gb in size, a lot of this data is old and could do with moving to
a new table to be archived so it would reduce the amount a procedure has to go through to
return a number of records. Was is the best way to do this ?

Perhaps have 2 tables

customer_orders customers_orders_history

copy the data from one table to another then remove the data from the orginal table (customer_orders) Received on Wed Jun 30 2004 - 09:21:04 CDT