Archives of the TeradataForum
Message Posted: Tue, 05 Apr 2005 @ 23:46:50 GMT
The DBQL StartTime is when the parser first sees the query. If you have workload limits (throttles in V2R6) in place, and if a query were to be delayed, that delay happens at the dispatcher level, downstream from the parser. A delay would cause what you are labeling as DBMS_time to include the time the query was waiting in the delay queue.
If you want to eliminate potential delay time, DBMS time could be expressed as FirstRespTime - FirstStepTime.
The FirstStepTime is the moment when the dispatcher sends the message for the first step to the AMP(s).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|