Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 15 Oct 2007 @ 19:44:19 GMT


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


Subj:   Re: Differences between Table Partitionings
 
From:   Bhattiprolu, Phaneendra

I do not think the following makes any difference either:

     CREATE SET TABLE ., NO FALLBACK,

            NO BEFORE JOURNAL,
            NO AFTER JOURNAL,
            CHECKSUM = DEFAULT
            (
             POSID INTEGER NOT NULL,
             BusinessDate DATE FORMAT 'yyyy/mm/dd',
             C096Amt FLOAT,
             C110Amt FLOAT,
             C400Amt FLOAT,
             C762Amt FLOAT,
             C772Amt FLOAT,
             C800Amt FLOAT,
             ProcessSourceID INTEGER,
             ProcessBatchID INTEGER)
       PRIMARY INDEX ( POSID ,BusinessDate )

       PARTITION BY RANGE_N(BusinessDate  BETWEEN '2004-04-01'(DATE)
       AND '2008-09-30'(DATE) EACH INTERVAL '1' DAY ,  NO RANGE, UNKNOWN);


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