Re: Performance problem - help appreciated.

From: VC <boston103_at_hotmail.com>
Date: Wed, 31 Mar 2004 23:07:35 GMT
Message-ID: <XaIac.148494$1p.1884679@attbi_s54>

Hello,

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:uvvl60lm23pa3e4hasvjmdkdq7lhp6n3ac_at_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.

Would you be able to post a query which would confirm your statement ? I am genuinely curious.

Thanks.

>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Wed Mar 31 2004 - 17:07:35 CST