·	Number of Subqueries

·	Joins versus EXISTS

·	WHERE versus HAVING

·	Avoid Grouping (DISTINCT / GROUP BY)

·	GROUP BY Parent Columns

·	Use Table Aliases

·	Use the SQL Definer

·	EXISTS versus IN