Re: 4 join methods?

On Friday 01 June 2001 06:30, Greg Moore wrote:
>
> Does anyone know where I can find any further information on MERGE JOIN
> (CARTESIAN)?
Ha! While reading your post, I was formulating a reply to you to ask the same question, then I saw the end of your post.

I just read the chapter on the Optimizer earlier this week, and don't recall seeing anything about the cartesian step, though I did see it in an explain plan earlier this week and wondered where it came from.

The join I was playing with was a simple one to test some other features, no cartesian product possible with it, yet there it was in the execution plan.

If you find any more on it, please share with the list.

Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

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).