Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 24 Aug 2005 @ 14:53:19 GMT


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


Subj:   Is USI useful for avoiding NUPI row check
 
From:   Agrawal, Sunil

In order to avoid the NUPI duplicate row check, we should enforce uniqueness by defining a USI. This will enhance the performance. Also Teradata document says that while inserting large number of records we should remove the SI and recreate them once the insertion is done which will improve the performance. Isn't these two statement contradicting each other because if we will remove the SI while inserting, this will allow duplicate row check.

Appreciate your help in clarifying this.


Regards,

Sunil



     
  <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: 27 Dec 2016