|
|
Archives of the TeradataForum
Message Posted: Thu, 08 Mar 2012 @ 13:02:21 GMT
Subj: | | Partitioning on different column to PI |
|
From: | | Mark Young |
Hi,
I was wondering if anyone could provide some advice on the use of partitioning in Teradata.
Is it possible to set up partitioning on a column that is not the primary index? If I have the PI setup on customer number which is the
primary key, so truly unique, can I then setup a partition based on dates, given that access id usually done by selecting a customer number
between two date ranges!
Mark
| |