Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 26 Oct 2007 @ 15:04:16 GMT

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

Subj:   Re: Set Tables with UPI
From:   Geoffrey Rommel

  The database checks the index for uniqueness rather than the entire row. Without it, each new row needs to be checked against every existing row.  

Au contraire ... each new row needs to be checked only against other rows with the same PI value; therefore, this check takes place on only one AMP.

  <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: 15 Jun 2023