Archives of the TeradataForum
Message Posted: Sat, 06 May 2006 @ 19:58:22 GMT
Subj: | | Re: Visual Explain help |
|
From: | | Stover, Terry |
I had a similar problem when we went through the 4.1.3 to 5.1 upgrade. I wrote an MS Access app to dump the explains into a local access
table. By making a copy of the query mdb and changing the odbc connection you can run the same queries against the test server. Then you can
write another query linking the tables in the old & new query mdb's to do detailed query by query analysis.
I don't totally trust explains for upgrade regression testing. I put a couple thousand of our frequently used and high priority queries in a
bteq. I included macros to reset the dbc.acctg cpu & io and peak spool before the query and log the results after each query. I ran the bteq
before we upgraded the test server then again after the upgrade to compare results on the same hardware. The 5.x DBQL takes care of the cpu &
io logging, but the peak spool logging isn't enabled on 5.1.
|