Archives of the TeradataForum

Message Posted: Tue, 31 Jan 2012 @ 09:31:37 GMT

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

<-- Anonymously Posted: Tuesday, January 31, 2012 00:09 -->

Hi,

I ran a simple SQL statement (part of bench mark queries) twice on a system on different days.? There are 21% difference on AMPCPUtime between them.?

One takes 652.3, the other 791.7.? It is the same SQL, platform, statistics, network.? No system setting changes at all.? The only difference is overall system CPU busy, but it is under 100%.? I would thought CPU usage of a single query should be relatively consistent on a system.

Has anyone encountered similar situation? Or any reason could make this variation happen?? It is TD13.10 platform

Thanks

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