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