StarRocks is a C++ analytical database that handles large-scale, high-concurrency, low-latency OLAP queries. In this presentation, Kaisen Kang, Tech Lead of the StarRocks Query Team, will provide an in-depth look at the StarRocks optimizer, the key optimizations, and design choices. The talk will focus on two key areas:

• Key Optimizations – A deep dive into three representative optimizations: Multi-left join colocate optimization, Partitioned Materialized Views auto union rewrite, and Low Cardinality global dictionary optimization, showcasing how they enhance query performance.
• Cost Estimation Challenges & Improvements – Lessons from real-world production use cases and the enhancements made to address them, including Auto Analyze, Query Feedback, Adaptive Execution, Predicate Columns, and SQL Plan Manager.

Finally, Kaisen will share insights and experiences from building the optimizer from the ground up over the past four years, reflecting on key design decisions and challenges.

This talk is part of the SQL or Death? Seminar Series.

Zoom Link: https://cmu.zoom.us/j/93441451665 (Passcode 261758)