Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 05 Dec 2012 @ 10:15:00 GMT


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


Subj:   Re: SET table with UPI
 
From:   sughesh iyyani

Hi Roopa,

Please find details below.

1. As you have defined a UPI, there won't be any duplicate check, with rows coming against rows exist.

2. As you have defined a UPI, there won't be any performance degradation. But if you defined only PI, TD will always do duplicate row check with all rows present in table. So there will be considerable degradation.

3. If you are using UPI, there is no improvement. But if you are using PI, there will be.


Thanks,

Sughesh I S.



     
  <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: 23 Jun 2019