Consider analyzing the EMPNUM column for each table as well, to provide the
CBO with possibly crucial data distribution information...
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, May 03, 2002 11:18 AM
> 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: Tim_at_SageLogix.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:46:26 CDT
