Archives of the TeradataForum

Message Posted: Thu, 02 Jun 2005 @ 19:54:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I can't answer your question. For the past data that you will purge, it is best to drop the partitions as it is the fastest way to remove data. Make sure you don't have 'NO range or unknown' turned on. If you have it turned on when a partition is dropped it just moves the data to the NO RANGE partition and takes a long time.

Example,

     alter table rdiehl.page_request
     modify primary index (session_id)
     drop range between DATE '2004-08-01' AND DATE '2004-08-31'  EACH
     INTERVAL
     ,drop  NO RANGE OR UNKNOWN;

Then you might want to add back NO RANGE.

Thanks,

Bob Diehl

	<Prev	Next>		<<First	<Prev	Next>	Last>>