Re: HASH JOINS -- PLEASE HELP ME
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: s.sethi@xxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Sat, 24 Jun 2006 08:41:25 -0700 (PDT)
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@xxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
