Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 04 Nov 2010 @ 16:50:21 GMT


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


Subj:   Re: Script to capture EXPLAINs
 
From:   John_Wight

Ulrich Wrote:

  How about the explain logging option in DBQL?  


Yes that is an option and we have the turned on and collect history for about 30 days, but it is rather difficult to identify the specific ones we want to track form one release to another (for Migration testing) as only the ProcID and QueryID are needed for both so you can get the before and after.

At the moment, I'm tending to LEAN to use VECOMP (Visual Explain/QCD DB) I can then do a compare with the utility after I run both - before and after versions.

Thanks Ulrich for your suggestion;-)


JK



     
  <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