· Number of Subqueries

 

· Joins versus EXISTS

 

· WHERE versus HAVING

 

· Avoid Grouping (DISTINCT / GROUP BY)

 

· Use Table Aliases

 

· Use the SQL Definer

 

· EXISTS versus IN

 

· Used Indexes