Archives of the TeradataForum

Message Posted: Tue, 21 Feb 2006 @ 18:06:55 GMT

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

This response is from the Teradata DBQL engineering team.

Using the view QryLogSteps instead of the base table:

     sel steplev1num (named step1), steplev2num (named step2), stepname,
     elapsedtime, rowcount, cputime, hotamp1cpu from qrylogsteps where
     queryid =  order by 1,2;

Regards,

Bill Putnam

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