Re: deciding which query plan to use

On 04/14/2004 08:04:59 AM, ryan.gaffuri_at_cox.net wrote:

> Anyone ever run into this situation? Where logical I/Os are radically reduced, but overall stress on the system > > is radically increased?

Well, you have to use something on your box. The thing is that you can't use disks and CPU simultaneously in most of the cases. So, if you cut down the number of I/O's, you'll use more CPU. It's sort of a natural thing, as much as anything about computers can be natural. I am expecting to see herbal computers with no fat or cholesterol any day now. Balancing will be much better with next generation of computers, the one which will have the RPM instruction implemented in the hardware.

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------