>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.

It would help if you posted the query and the execution plan to figure out what is going on.