Archives of the TeradataForum
Message Posted: Fri, 01 Feb 2013 @ 13:51:28 GMT
Subj: | | Re: Query Execute time |
|
From: | | Prescott, Kyle R |
From DBQLogTbl you can use the following timestamp calculations that will give you an interval data type - hours:minutes:seconds.n(6):
First step time minus query start time = parse/optimize phase
First response time minus first step time = execute time
First response time minus start time = total time or wall time
,firststeptime - starttime hour(4) to second as ParseOptimizeTime
,firstresptime - firststeptime hour(4) to second as QueryExecTime
,firstresptime - starttime hour(4) to second as WallTime
Kyle Prescott
DBA Manager
Unum-GHDS
Chattanooga, TN
|