General SQL Tuning Tips

Previous Next

This section contains general optimization tips in the area of writing SQL statements.

Related Topics

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

Used Indexes