RE: SMJ, NL or HJ

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Fri, 03 May 2002 09:18:28 -0800
Message-ID: <F001.00457819.20020503091828@fatcity.com>

('binary' encoding is not supported, stored as-is)
Depends. The number of rows matching a given FK may vary widely. Collect stats, and let the CBO decide, it should not have it too wrong in such a case.

>----- Original Message -----
>From: Rajesh.Rao_at_jpmchase.com
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Fri, 03 May 2002 08:13:27
>
>Hello Gurus,
>
>A SQL tuning question. Given three large tables
>with the same millions of
>rows, and all three are referenced in a query,
>without any filter, as
>under:
>
>Select ..............................
>from largetableA a, largeTableB b, largeTableC c
>where a.empnum = b.empnum
>and a.empnum = c.empnum;
>
>What would be the prefered way of joining these
>tables, Merge Join, Nested
>Loops or Hash Joins?
>
>Thanks
>Raj
>
>--
>Please see the official ORACLE-L FAQ:
>http://www.orafaq.com
>--
>Author:
> INET: Rajesh.Rao_at_jpmchase.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).
>---------------------------------------------------
>-----------------

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: sfaroult_at_oriolecorp.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).

Received on Fri May 03 2002 - 12:18:28 CDT