MySQL's query optimiser...

[untermensch]

doesn't.

Given a free day, I could write a better optimiser for a whole set of obvious general query semantics which they've neglected to even think about.