Archives of the TeradataForum
Message Posted: Fri, 31 Dec 2004 @ 10:38:33 GMT
| Subj: || || Variation in Metrics from dbc.ampusage |
| From: || || Anomy Anom |
<-- Anonymously Posted: Friday, December 31, 2004 00:35 -->
We measure the amount of resource consumed by an SQL using DBC.AMPUSAGE table [ASE Expansion]. What we have noticed is when the same SQL is
being executed we are getting different results. We have ensured that only one session of the login is used. Any reason why we should see
variations in resource consumed, data demographics being the same?