Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 15 Oct 2007 @ 16:05:34 GMT


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


Subj:   Differences between Table Partitionings
 
From:   Martinez, Joseph

Is there a difference in how TD partitions the between the following statements:

     1) 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 '2004-09-30'(DATE) EACH INTERVAL '1' DAY ,
        '2004-10-01'(DATE) AND '2005-09-30'(DATE) EACH INTERVAL '1' DAY ,
     *  '2005-10-01'(DATE) AND '2006-09-30'(DATE) EACH INTERVAL '1' DAY ,*
     *  '2006-10-01'(DATE) AND '2007-09-30'(DATE) EACH INTERVAL '1' DAY ,*
     *  '2007-10-01'(DATE) AND '2008-09-30'(DATE) EACH INTERVAL '1' DAY ,*
        NO RANGE, UNKNOWN);



     2) 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 '2004-09-30'(DATE) EACH INTERVAL '1' DAY ,
        '2004-10-01'(DATE) AND '2005-09-30'(DATE) EACH INTERVAL '1' DAY ,
     *  '2005-10-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