Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CBO calculates lower cost, but runs slower...

Re: CBO calculates lower cost, but runs slower...

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Tue, 20 Nov 2001 09:43:03 GMT
Message-ID: <3bfa2578.4831636@news> 





In a sudden spasm of awareness,


Jonathan Lewis doodled thusly:



>

>For a given SQL statement and optimizer goal, the

>lowest cost is supposed to be the fastest query path.




Even across databases, Jonathan?  I got the feeling his problem was
that one db gave him one result, the other another.




Cheers


Nuno Souto


nsouto_at_optushome.com.au.nospam
Received on Tue Nov 20 2001 - 03:43:03 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US