RE: 4 join methods?

Cartesian Join? <shudder>

Scott Shafer
San Antonio, TX
210-581-6217

"And no amount of training or preparedness can eliminate the almost certainty that in the middle of your Angry Crane stance, as you transition to your Combative Monkey to administer the Coup de Grāce via your Ninja Death Touch, you step on a beer bottle and fall backwards into the juke box and get your head stove in by a drunk with a pool cue." --Jay Trigg

> -----Original Message-----
> From: Greg Moore [SMTP:sqlgreg_at_pacbell.net]
> Sent: Wednesday, May 30, 2001 9:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 4 join methods?
>
> Hi,
>
> I just read there are four join methods. I know three:
>
> Nested loops
> Sort merge
> Hash join
>
> What's the fourth?
>
> - Greg
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

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