Forum

Normal join or left...
 
Share:
Notifications
Clear all

Normal join or left outer join which give more performance?

2 Posts
1 Users
0 Likes
295 Views
VK
Posts: 36
 VK
Guest
Topic starter
(@VK)
Eminent Member
Joined: 2 years ago

Which joins are faster? 

1 Reply
Info User
Posts: 47
 Info User
Guest
(@Info User)
Eminent Member
Joined: 2 years ago

As far as I know Normal join will give you the better performance becase it simply filter the rows based on the join condition equal or inner.

Wheras outer joins follow the concept called matching and non matching rows it has to look for both, thats why it is less faster than other joins.

Hope it helps. 

Reply

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: