Query Optimization

Subquery Optimization

Join Optimization

Rewrite OR to UNION

Convert subqueries

Test alternatives

Common rewriting patterns?

OR to UNION?

When to rewrite?

Query Rewriting

Optimization Patterns