Archives of the TeradataForum

Message Posted: Fri, 05 Sep 2003 @ 16:02:44 GMT

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

I'd use PMON and look at the disk io and cpu time for the query. Execution time isn't reliable unless you're the only user on the server. Queryman is good for timing individual queries. For testing new batch processes I put them in BTEQ and add a step to write to a log table between each query.

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