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
Messages: 33
Registered: February 2007
Location: kolkata
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: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Previous Topic: Help - Rows accessed in FTS and Explain Plan
Next Topic: Some basic tuning steps
Goto Forum:

Current Time: Thu Aug 17 14:30:44 CDT 2017

Total time taken to generate the page: 0.12297 seconds