Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 27 Feb 2013 @ 12:32:10 GMT


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


Subj:   Re: Performance of MERGE vs UPSERT
 
From:   Ranga, Dixit

Merge/Stack Merge is pretty useful when you go for update on huge table, since it updates rows on block by block.

Update updates the rows on row by row level.

So most of the time Merge saves execution time, CPU cycles and spool space.


Thanks.



     
  <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