![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Mon, 15 Oct 2007 @ 16:05:34 GMT
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);
| |