 |
 |
Archives of the TeradataForum
Message Posted: Thu, 18 Nov 2004 @ 09:10:52 GMT
| Subj: | | Re: PMON explain for running query - Large discrepancy between "Estimated I/O" and "Actual I/O" |
| |
| From: | | Howard Bradley |
I have noticed the same thing. In some cases it appears that the larger number is exactly the smaller number multiplied by the number of Amps
on our system and so I assumed that the 2 figures were reporting at 2 different levels, global and Amp. This isn't always the case though. I have
also noticed that we often get negative estimates but assumed this was some sort of overflow problem.
| |
