2. optd book
  3. The Core
    1. Plan Representation
    2. Memo Table and Logical Equivalence
    3. Cascades Framework
      1. Basic Cascades Tasks
      2. Cycle Avoidance
      3. Upper Bound Pruning
      4. Multi-Stage Optimization
    5. Rule IR and Matcher
    6. Cost and Statistics
    7. Logical Properties
    8. Physical Properties and Enforcers
      1. Memo Table: Subgoals and Winners
      2. Cascades Tasks: Required Physical Properties
    10. Exploration Budget
    11. Heuristics Optimizer
  5. Integration with Datafusion
    1. Datafusion Plan Representation
    2. Datafusion Bridge
    3. Rule Engine and Rules
    4. Basic Cost Model
    5. Logical and Physical Properties
    6. Optimization Passes
    7. Miscellaneous
    8. Explain
  7. Research
    1. Partial Exploration and Re-Optimization
    2. Advanced Cost Model
    3. The Hyper Subquery Unnesting Ruleset
  9. Testing and Benchmark
    1. sqlplannertest
    2. sqllogictest
    3. perfbench
  11. Debugging and Tracing
    1. optd-core Tracing
    2. Memo Table Visualization
    3. Optimizer Dump
  13. Contribution Guide
    1. Install Tools
    2. Contribution Workflow
    3. Add a Datafusion Rule
  15. What's Next
    1. Ideas
    2. RFCs
  20. DEPRECATED
  21. old optd book
    1. Core Framework
      1. Optimizer
      2. Plan Representation
      3. Rule Engine
      4. Cost Model
      5. Properties
    3. Integration
      1. Apache Arrow Datafusion
    5. Adaptive Optimization
      1. Re-optimization
      2. Partial Exploration
    7. Demo
      1. Three Join Demo
      2. TPC-H Q8 Demo
    9. Performance Benchmarking
      1. Cost Model Cardinality Benchmarking
    11. Functional Testing
      1. SQLPlannerTest
      2. Datafusion CLI
    13. Miscellaneous