you need to explain in detail what you are doing hash joins are in memory joins . so to make a hash join return a result set faster you need to give it more memory
from orafaqs
Hash Join
Join optimization method where two tables are joined based on a hashing algorithm. Also see Sort Merge Join, Nested Loops Join and Cluster Join.
Hashing
.
but again unless you explain what you want to achieve an answer might not be possible .
- Original Message ----
From: Ravindra K Singh <s.sethi_at_telserra.com>
To: oracle-l_at_freelists.org
Sent: Saturday, June 24, 2006 4:56:41 AM
Subject: HASH JOINS -- PLEASE HELP ME
WHAT IS HASH JOIN IN ORACLE , HOW TO MAKE FAST HASH JOINS
Thanking You.
With Best Regards
SACHIN
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jun 24 2006 - 10:41:25 CDT
