Dynamic Queries Optimization

[Irfan Ali]

In my app i saw many queries fetches information with different criteria (changing in WHERE clause) and changes in GROUP BY or ORDER BY clause.

How to optimize those queries ?
Should i use different strategy. SP or Prepared statements ? What is the best alternative for those dynamic queries if it's impossible to tune dynamic queries.

SELECT * FROM table WHERE id=1 GROUP BY id ORDER BY date DESC;
SELECT * FROM table WHERE username='abc' ORDER BY id;
SELECT count(userid) FROM table WHERE email='[e-mail]' GROUP BY userid ORDER BY id DESC;