![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Tue, 12 May 2009 @ 12:15:26 GMT
Subj: | | Re: Columns Part of Partitioning Expression |
|
From: | | Geoffrey Rommel |
I can't answer your question, but I wanted to note one thing about your table definition.
> Column1 INTEGER NOT NULL ,...
> PARTITION BY RANGE_N(Column1 BETWEEN 200612 AND 200712 EACH 1)
This will create 101 partitions for 200612, 200613, 200614, ... 200699, 200700, 200701, etc. That's probably not what you want,
right?
If you need codes in your database to represent months, I suggest something like (year - 1990) * 12 + month. This will fit into a smallint with
no gaps between months.
| |