Archives of the TeradataForum
Message Posted: Sat, 10 Mar 2012 @ 22:41:09 GMT
| Subj: || || Re: Partitioning on different column to PI |
| From: || || Pluebell, Fred |
If you primarily do non-equality comparisons on the date, you won't want to define the PI as containing both customer number and date.
Based on the information you have provided, you likely want the customer number to be the PI; just don't declare it as UNIQUE (even if the
values are unique). Partition based on the date column. Then if you want the database to enforce uniqueness for the customer number, define a