Normal join or left outer join which give more performance?
Which joins are faster?
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.