Optimization Strategy
Query optimization means finding the best execution strategy.
- Usually means "picking the best plan" rather than fiddling with some given plan
General strategy
- Generate a number of plans
- Evaluate each using statistics in the DB catalog
- Pick the best one (or at least a good one)