Archives of the TeradataForum

Message Posted: Fri, 18 Feb 2011 @ 10:14:42 GMT

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

Hi,

Always use starttime instead of collecttimestamp when querying DBQL. Both normally differ by few seconds to minutes.

I saw the difference between these two times in hours when the query got delayed for hours by throttled object delay rules.

Starttime represents the time when the query entered into teradata system, whereas the collect timestamp represents DBQL collect time for that buffer.

Just for information, there is another field firststeptime, which represents when the sql started execution.

Regards,

Sivaji GV

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