Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 16 Nov 2010 @ 07:54:37 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Teradata Archive Solution
From:   Anomy Anom

<-- Anonymously Posted: Monday, November 15, 2010 19:11 -->

Hi Mark,

I forwarded your question to a Teradata developer. His response was:

WITH DELETE/WITH INSERT is not really a space or performance feature. It just says what to do with rows that no longer have a partition. What do with those rows should be more of decision in regard to what data the user wants to keep on the system.

The ALTER statements will not work since the user cannot drop or add partitions in the middle, only at the end.

In any case, without changing the partitioning, can just use a DELETE statement to delete unwanted rows after archiving them if the user wants to save them offline.

Hope this helps!


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023