Archives of the TeradataForum
Message Posted: Thu, 04 Nov 2010 @ 16:50:21 GMT
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
|