Forum

Normal join or left...
 
Notifications
Clear all

Normal join or left outer join which give more performance?


VK
Posts: 36
 VK
Topic starter
(@VK)
Joined: 1 year ago

Which joins are faster? 

1 Reply
Info User
Posts: 47
 Info User
(@Info User)
Joined: 1 year 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
Share: