>Is it just my observations or Left Join does not affect the execution plan?
>
>I have made some tests so far and if I have this line or not, it does not affect the execution plan. On some of my tests, I had multiple and this resulted in the same.
May be this query will return the same result without LEFT JOIN. Otherwise I find it very hard to believe.
If it's not broken, fix it until it is.
My Blog