Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 19 Jun 2008 @ 10:23:41 GMT


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


Subj:   Re: V12, MERGE Logic: 1) Restriction inserts; 2) PPI behavior
 
From:   Fred W Pluebell

You didn't provide enough info regarding the performance.

Do the EXPLAINs differ? And if so, how?

Particularly if the EXPLAINs seem to match, consider running with DBQL STEPINFO logging. You may find the extra time is actually being spent in the SELECT part (USING) rather than INSERT (or UPDATE).



     
  <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: 28 Jun 2020