Dear all,
I understand join is for joining two tables, I know nested loops and
sort-merge joins and I know how they work and on what situation theyre
used best at. But I really dont understand hash join, how are they
working to join tables and on what situation they performed best? And
based on
read the docs. otn.oracle.com
click on search. do a search for hash join.
The docs are very good. read them.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 15, 2004 8:34 AM
> Dear all,
>
> I understand join is for joining
[EMAIL PROTECTED]>
>To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]>
>Subject: What is Hash Join?
>Date: Thu, 15 Jan 2004 20:39:29 +0700
>
>
>
>
>Dear all,
>
>I understand join is for joining two tables, I know nested loops and
>sort-merge joins and I
a by that hash key for
> matching
> records
> output the matches
>end loop
>
> So, a hash join can sometimes be much more efficient (one hash, not two
> sorts)
>
> Hash joins are used any time a sort merge might be used in most cases.
> If
> you
> do
