Archives of the TeradataForum

Message Posted: Sat, 10 Mar 2012 @ 22:41:09 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>