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: Performance problem - help appreciated.

Re: Performance problem - help appreciated.

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 31 Mar 2004 19:30:21 +0200
Message-ID: <uvvl60lm23pa3e4hasvjmdkdq7lhp6n3ac@4ax.com> 





On Tue, 30 Mar 2004 22:38:43 GMT, "VC" <boston103_at_hotmail.com> wrote:



>I am sorry to say that but the order of tables in the FROM clause is simply

>irrelevant since the CBO re-arranges them as it sees fit -- ther is no

>notion of the 'drivng' table under CBO. The order does matter under the RBO.




I'm sorry to say my experience is to the contrary.
The order does matter.



--
Sybrand Bakker, Senior Oracle DBA


Received on Wed Mar 31 2004 - 11:30:21 CST












Original text of this message













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