Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 21 Nov 2006 @ 22:07:32 GMT


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


Subj:   Re: Problem with first production use of PPI & JI
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, November 21, 2006 16:05 -->

I suppose EXPLAINs before and after are too much to hope for...

First thing you need to figure out is where it's spending the extra time. For example, is it in FETCH/JOIN part of the INSERT/SELECT or the MERGE part? Don't rely on EXPLAIN for this; monitor it as it runs or use DBQL STEPINFO. Then if the problem isn't obvious, post more details and maybe someone can help.



     
  <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