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
|