Hi Greg,
I think Tim is right. I've read all the thread and
among all other suggestions cluster join might have been the
best answer. But if I remember correctly it is a kind of N-L
Now going to read the article. Thanks for the link
Regards,
Ed
>
> I also sent an inquiry to Tim Gorman, who wrote the article
> on the CBO.
> He's no novice. He says the fourth join method is....
>
> 1. nested loops
> 2. sort merge
> 3. hash join
>
> and....
>
> 4. cartesian product !
>
> I kid you not.
>
> By the way, if you're on 8i and haven't already set init parms
> OPTIMIZER_INDEX_CACHING=90 and OPTIMIZER_INDEX_COST_ADJ to
> something between
> 10 and 50, you might really like this article he wrote, "The
> Search for
> Intelligent Life in the CBO." Currently it's the fist
> article listed at
> http://www.evdbt.com/library.htm
>
> - Greg
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Greg Moore
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shevtsov, Eduard
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
