·	Number of Subqueries

·	Joins versus EXISTS

·	WHERE versus HAVING

·	Avoid Grouping (DISTINCT / GROUP BY)

·	GROUP BY Parent Columns

·	Use the SQL Definer

·	EXISTS versus IN

·	Used Indexes