Thanks for your explanation.

So, should I conclude that I do not have to rely on Execution Plan for optimization of my query. Instead, I should check it only for any execution warnings, index usage, look ups, table scan, etc.

And does same applies to I/O stats !!