Current optimizer is rule-based (4 rules: predicate pushdown, projection pruning, constant folding, limit pushdown).
Cost-based optimization needs:
- Table statistics (row count, distinct values per column, histograms)
- Cost model (estimate I/O, CPU, network for each operator)
- Plan enumeration (compare alternative plans)
- Join reordering
- Hash join vs nested-loop selection
Spec: docs/superpowers/specs/2026-04-04-optimizer-design.md (architected for this extension)
Current optimizer is rule-based (4 rules: predicate pushdown, projection pruning, constant folding, limit pushdown).
Cost-based optimization needs:
Spec:
docs/superpowers/specs/2026-04-04-optimizer-design.md(architected for this extension)