Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 16 Feb 2006 @ 22:06:33 GMT


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


Subj:   DBQL STEPINFO Sql
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, February 16, 2006 12:22 -->

I'm trying to collect the rowcount, timetaken for each step and HotAMP in the explain for a particular query. We need to eliminate some steps from dbc.dbqlsteptbl to get exact match of the explain. If I select from the latest collecttimestamp, the StepStartDate and StepStopDate for some steps are not latest. I'm trying to write a simple sql that would give me the exact match of the explain, with the StepNo, StepName, StepStartTime, StepStopTime, Rowcount, HotAMP. I also want to do this without entering anything manually.

Right now I get all the rows and then enter the values for the timestamp manually to filter out the rows I understand this has some homework to do, but if someone has a ready-made SQL, it would be great.

I'm looking something like below.

     /* Enable query logging for this query alone*/
     BEGIN QUERY LOGGING WITH SQL, STEPINFO ON ;

     /* Submit the SQL */

     /*Diable query logging */
     END QUERY LOGGING ON ;

     /* SQL that displays the STEPINFO and matches exaclty with the explain
     */

Thanks in advance !



     
  <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