I think most databases have an internal query optimizer anyway don't they? so they look at your query... and then decide the best way to run it... and that's what they run?
(I'm no DB expert, and NS might operate differently from DBs generally anyway)