Normal join or left...
Clear all

Normal join or left outer join which give more performance?

Posts: 36
Topic starter
Joined: 2 years ago

Which joins are faster? 

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