Archives of the TeradataForum
Message Posted: Thu, 16 Feb 2006 @ 22:06:33 GMT
<-- 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
Thanks in advance !
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|