Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Left Join vs Right Join

Status
Not open for further replies.
shaunk

shaunk

Programmer
Aug 20, 2001
402
AU
I have read that the two following joins are identical:

Table A Left Join Table B and
Table B right join Table A

They produce the same result set but are radically different in run times.

Is there an efficiency difference between the two?
 
Sort by date Sort by votes
but are radically different in run times
And which is faster ?
 
Upvote 0 Downvote
The left join is faster by almost 30% as run from SQL Server Query Analyser.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
Cross Join in an Insert Into
Replies
1
Views
206
carp
carp
SashaBuilder3
  • Locked
  • Question
left join with "soft" condition
Replies
2
Views
123
SashaBuilder3
SashaBuilder3
rivi10
  • Locked
  • Question
Join query 1
Replies
3
Views
89
rivi10
rivi10
mmy1981
  • Locked
  • Question
select distinct and left join
Replies
2
Views
103
mmy1981
mmy1981
agp4
  • Locked
  • Question
Left Join Query 1
Replies
1
Views
56
jaxtell
jaxtell

Part and Inventory Search

Sponsor

Back
Top