Performance Tuning

Add the correct index

Don't hide in function

OR

Set the cache correctly

JOIN GROUP BY

Negatives

0Have an INDEX

Subqueries

Avoid inefficient constructs