Home » RDBMS Server » Performance Tuning » Difference between Joins
Difference between Joins [message #64725] Sun, 11 January 2004 21:22 Go to next message
Messages: 16
Registered: July 2003
Junior Member

In execution plan I see various kinds of joins such as Nested Loop Join, Hash Join, Sort Merge Join etc

My question is What are the different types of Joins and how does it work and which type of join is better.

Thanks in advance for the reply

Re: Difference between Joins [message #64741 is a reply to message #64725] Thu, 15 January 2004 11:16 Go to previous message
Messages: 1089
Registered: May 2002
Senior Member
Performance_Tuning Guide

Previous Topic: Start SQL*PLUS or SQL WorkSheet with problems.
Next Topic: Select .... from and performance issues
Goto Forum:

Current Time: Wed Feb 21 09:08:58 CST 2024