Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 06 May 2006 @ 19:58:22 GMT


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


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.



     
  <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