RE: 4 join methods?

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: sqlgreg_at_pacbell.net
>
> 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: ListGuru_at_fatcity.com (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: EShevtsov_at_flagship.ru

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: ListGuru_at_fatcity.com (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).