Why does the MySQL optimizer not do what I think it should? – Sheeri ...