Home » RDBMS Server » Performance Tuning » merge join and hash join
merge join and hash join [message #234146] Mon, 30 April 2007 03:27 Go to next message
p.bhaskar
Messages: 33
Registered: February 2007
Location: kolkata
Member
can anyone explain me for large tables and huge join condition in where clause of query which join is useful and why?

pls help me
Re: merge join and hash join [message #234207 is a reply to message #234146] Mon, 30 April 2007 08:11 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14211/optimops.htm#sthref1364
Previous Topic: Help - Rows accessed in FTS and Explain Plan
Next Topic: Some basic tuning steps
Goto Forum:
  


Current Time: Fri Dec 09 23:32:44 CST 2016

Total time taken to generate the page: 0.25830 seconds