The general school of thought is joining a large table
to a small one. There is an article on Metalink thats
a little out of date now, but it describes the
good/the bad, and tuning of hash joins.
Look for doc 67134.1 and 41954.1
hth
connor
- Kevin Kostyszyn <kevin_at_dulcian.com> wrote: >
What's the performance (gain/loss) on such a join,
> when would you want to
> use one?
> Kev
>
> -----Original Message-----
> McDonald
> Sent: Thursday, May 31, 2001 6:00 AM
> To: Multiple recipients of list ORACLE-L
>
>
> A method of joining two tables. You scan each and
> use
> a hashing algorithm to isolate/match keys.
>
> hth
> connor
>
> --- Senthil Ganapathi
> <senthil.ganapathi_at_mannai.com.qa> wrote: >
> > Hi Rukmini
> > could tell me what's that hash-join
> >
> > GSK
> >
> >
> >
> >
> > "Rukmini
> >
> > Devi" To:
> > Multiple recipients of list ORACLE-L
> > <rukmini_at_indb
> > <ORACLE-L_at_fatcity.com>
> > rain.com> cc:
> >
> > Sent by: Subject:
> > Re: 4 join methods?
> > root_at_fatcity.
> >
> > com
> >
> >
> >
> >
> >
> > 31-05-01
> >
> > 09:55 AM
> >
> > Please
> >
> > respond to
> >
> > ORACLE-L
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > 1. Equi-join 2. Self-join 3. Outer-join
> 4.
> > Hash-join
> >
> > rukmini
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>
> > Sent: Thursday, May 31, 2001 11:20 AM
> >
> >
> > > i feel the fourth one is self join.
> > >
> > > ----- Original Message -----
> > > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > > Sent: Thursday, May 31, 2001 8:10 AM
> > >
> > >
> > > > 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: 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: Saurabh Sharma
> > > INET: saurabhs_at_fcsltd.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: Rukmini Devi
> > INET: rukmini_at_indbrain.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: Senthil Ganapathi
> > INET: senthil.ganapathi_at_mannai.com.qa
> >
> > 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
>
=== message truncated ===
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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 Thu May 31 2001 - 12:49:22 CDT
