In this talk, I will give an introduction to Snowflake’s query optimizer. I will talk about the main features of Snowflake’s optimizer, explain the main philosophy behind the design decisions, and delve into some unique aspects of the implementation. I will also later expand into our infrastructures to facilitate optimizer development and discuss the opportunities and challenges for implementing and rolling out query optimizations for cloud-based databases.

This talk is part of the Quarantine Database Tech Talk Seminar Series.

Bio:
Jiaqi Yan is a software engineer at Snowflake Computing. His main work spans Snowflake's query engine, serverless features, and engineering infrastructure. He currently leads development of performance improvements for Snowflake's query compiler and optimizer. Before joining Snowflake, Jiaqi was a software engineer at Oracle.

More Info: https://db.cs.cmu.edu/seminar2020/