I have actually set up a maintenance plan, for indexes and statistics, that works pretty well. And I don't really have performance issues at this point. But as I was working on that maintenance plan, I was thinking about performance and the question about the way query plan, popped into my mind.

But thank you so much for all your replies and for clarifying things for me, in that regard.