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

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
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Performance_Tuning Guide

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


Current Time: Thu Oct 01 03:11:23 CDT 2020