Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Jan 2013 @ 14:20:14 GMT


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


Subj:   MERGE Vs UPSERT in a table having MPPI
 
From:   sughesh iyyani

Hi Experts,

We have a huge table having more than 12 Billion rows and Multi level PPI on it.

Currently we are doing Delete + Insert as there is a huge volume of data need to get updated.

We are thinking of changing it into UPSERT or MERGE INTO.

Did anybody did any performance comparison on these?

We want to know which will perform better and which is better under which scenario.

Appreciate your time.


Thanks in advance,

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