Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 18 Aug 2004 @ 22:53:15 GMT


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


Subj:   Re: UNION And INSERT INTO
 
From:   Christie, Jon

You're right. I don't know what I was thinking. If the select is a union, the insert should be able to bypass dupe checking. Somewhere along the line, I think they put that enhancement in, but I'm not sure at what version.

But dupe checking overhead IS highly data dependant. With lots of NUPI dupes, it's expensive. Otherwise, it's not.



     
  <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