Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 01 Dec 2012 @ 19:04:19 GMT


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


Subj:   Re: SET table with UPI
 
From:   Lenka, Dipti Prakash

Ideally there should not be performance degradation because when the index UPI is there optimizer overrides all other duplicate checks. So if UPI is there then it doesn't matter table is SET or MULTISET.


Thanks,

Dipti Prakash



     
  <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