OraFAQ Forum: Performance Tuning » merge join and hash join

Home » RDBMS Server » Performance Tuning » merge join and hash join

Mon, 30 April 2007 03:27

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

Mon, 30 April 2007 08:11

Mahesh Rajendran
Messages: 10708
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: Tue Jun 16 16:36:23 CDT 2026