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 derfloh 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
Joined
Aug 20, 2001
Messages
402
Location
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 Question
Cross Join in an Insert Into
Replies
1
Views
579
carp
carp
SashaBuilder3
  • Locked
  • Question Question
left join with "soft" condition
Replies
2
Views
365
SashaBuilder3
SashaBuilder3
rivi10
  • Locked
  • Question Question
Join query
Replies
3
Views
320
rivi10
rivi10
mmy1981
  • Locked
  • Question Question
select distinct and left join
Replies
2
Views
300
mmy1981
mmy1981
agp4
  • Locked
  • Question Question
Left Join Query
Replies
1
Views
211
jaxtell
jaxtell

Part and Inventory Search

Sponsor

Back
Top