Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: io rate - join
Still doesn't make sense. Too many factors come into play. Above all
you are querying the detail table (for nothing) over and over and over
again. Assuming your physical I/O (at the Oracle level) is high (and
obviously you didn't investigate this), you will be reading the same
disk blocks over and over and over again, and you will suffer from
disk latency. But then you are conducting an useless experiment to
demonstrate how you can screw up a database, so who cares?
Another bitter man. Is this not D Morgan? Received on Tue Jul 12 2005 - 15:23:17 CDT