Archives of the TeradataForum
Message Posted: Tue, 31 Jan 2012 @ 09:31:37 GMT
<-- Anonymously Posted: Tuesday, January 31, 2012 00:09 -->
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|