Archives of the TeradataForum

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

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

<-- 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>>