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>>