Hi Ken, if you wish I've some samples where QO can and do change your queries to get better performance...
I think the main point about this topic is to understand what is happening, and why something is not good for performance (in terms of code optimization).
I agree that sometimes is hard to apply change in a production environment, but unfortunately that’s life ?. But this still cheaper than an hardware improvement.
Cheers
[]s
Fabiano Amorim