Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Wed, 06 Jul 2005 @ 19:19:31 GMT





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




Subj:   Re: Partitions and indexes
 
From:   Anantaraman, Kumaran (K.)



Correction, I meant to say -

TD has to check for duplicate UPIs when inserting rows. If all partition columns are not included in UPI, then TD may have to search IN ALL partitions for existing rows with same UPI values that may conflict with new incoming row.


Kumaran Anantaraman





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008