Re: Dynamic Queries Optimization

[Rick James]

MySQL's optimizer always dynamically decides how to optimize each query. Don't worry. (This is unlike what some competitors do.)

WHERE id=1 GROUP BY id -- Why have the GROUP BY?

WHERE id=1 ORDER BY date DESC; -- needs INDEX(id, date)

WHERE id=1 ORDER BY date DESC; -- The ORDER BY is useless if id is UNIQUE.

WHERE username='abc' ORDER BY id; -- needs INDEX(username, id)

SELECT count(userid) FROM table WHERE email='[e-mail]' GROUP BY userid ORDER BY id DESC; -- this ORDER BY does not make sense in this context.

Maybe those are not real queries?