This section contains general optimization tips in the area of writing SQL statements.
See Also:
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
