Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


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



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020