Forum

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

Normal join or left outer join which give more performance?


Posts: 36
 VK
Guest
Topic starter
(@VK)
Eminent Member
Joined: 4 years ago

Which joins are faster? 

1 Reply
Posts: 47
Guest
(@Info User)
Eminent Member
Joined: 4 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

Self Learning Video Tutorials - Software Course

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: