Building modern SQL query optimizers with Apache Calcite
summary
Apache Calcite provides a Java planner that implements cost-based and heuristic drivers plus a flexible rule engine that performs bottom-up and top-down rewrites. It ships with hundreds of built-in rewrite rules and extensible adapters that map logical operators to physical implementations, supports plan enumeration and costing, and produces executable plans for different engines. Examples include rule matching for join reordering, pushing filters, and converting to physical joins so teams can measure actual performance gains.
AI-written summary · about
chapters (8)
- 0:00Introduction to SQL optimizers
- 5:33Apache Calcite overview
- 10:14Syntax and semantic analysis
- 15:56Transformation rules and execution
- 21:39Heuristics and optimization strategies
- 27:58Project examples and use cases
- 33:35Advanced features and flexibility
- 37:49Conclusion and Q&A
related talks
58mApache Calcite: A Platform for Building Advanced SQL Optimizers on Java
41mStreaming SQL
41mImplementing Piped Processing Language in OpenSearch Via Apache Calcite
47mTaking a look under the hood of Apache Flink’s relational APIs
01h 04mQuery Optimization and Acceleration at Dremio
51mHow Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of
41mHydra's Heads – Vladimir Ozerov
50mHow SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of