Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020