· 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