On Wed, 30 Jun 2004 15:21:04 +0100, "Mill" <mill.h_at_ntlworld.com>
wrote:
>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)
>
>
How 'bout just partitioning customer_orders on order date? Or perhaps
a combination of order date and order status?
Received on Wed Jun 30 2004 - 12:39:21 CDT
