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

 

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 22:25:18 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.