Home » RDBMS Server » Server Administration » Hash Join
Hash Join [message #59472] Mon, 24 November 2003 18:52 Go to next message
Sujit Sarkar
Messages: 40
Registered: September 2003
Member
Hi Friends,
Can anybody explain me what is "Hash Join".
I have heard about other type of Joins e.g Cartesian Jojn,Equi Join,
Self Join and Outer Join . I am not getting this type of Join(Hash Join).

Examples are highly Appreciated.

Thanx in Advance

Sujit

Report message to a moderator

Hash Join is a different thing [message #59476 is a reply to message #59472] Tue, 25 November 2003 01:53 Go to previous message
Thomas G.
Messages: 10
Registered: November 2003
Junior Member
The things you mentioned are different ways to make a join in a query.

"nested loop", "sort merge" or "hash join" are the three methods Oracle has for *executing* that join internally.

Seach for "hash join" in this

http://www.macs.hw.ac.uk/~hamish/ps/oracle.pdf

for more in-depth information.

Report message to a moderator

Previous Topic: ORA-19502 on Windows NT 4.0 with lots of Space
Next Topic: oracle on linux installation error(jre)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:27:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.