Wednesday, November 22, 2006

How Oracle Hash Join works?

Hash Join is one of join used by Oracle server when we joine multiple table. Following link will give you a demo on Flash. This demo explains how Hash Join works in Oracle.
This demo was created by TomKyte from Oracle. I got this link from AskTom.

http://tinyurl.com/l2qsh

Alternatively, if you want "offline viewing" of this, you can download a .exe
file (about 1.8mb) that lets you play this whenever you want:

http://tinyurl.com/nyjro

No comments: