Re: [Q] What's the Hash join?

From: <kal121_at_yahoo.com>
Date: Fri, 09 Apr 1999 20:27:46 GMT
Message-ID: <7elnrp$4hb$1@nnrp1.dejanews.com>

A hash table is constructed for the larger of the two tables. The smaller table is then scanned, and the hash table is used to find matching rows in the smaller table. - from Oracle SQL High Performance Tuning by Guy Harrison (very good book by the way)

You can implement the hash join through the use of a hint /* USE HASH */ - check your docs for the exact syntax

But my recommendation is, don't use it if you don't understand the benefits of the hash join

In article <m3vhfajdz4.fsf_at_angra.lgic.co.kr>, angra_at_maninet.co.kr wrote:
>
> Hi, Oracle guru.
>
> I wonder what's mean hash join and How can I use hash join?
>
> Thanks in advance.
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 09 1999 - 15:27:46 CDT