Dive into a technical conference talk where Bill McKenna, Principal Software Engineer at Ahana and pioneer in database optimization, explores modern query optimizers with a focus on Presto's evolution. Learn about the current state of query optimization technology, understand how Presto compares to other modern systems, and discover the planned improvements for Presto's query optimizer. Gain deep technical insights from McKenna's extensive experience, including his work as the architect for Amazon Redshift's query optimizer and his co-authorship of The Volcano Optimizer Generator. Master complex database theory concepts while exploring the technical roadmap for one of the industry's leading distributed SQL query engines.
Overview
Syllabus
The Future of Presto's Query Optimizer - Bill McKenna, Ahana
Taught by
Presto Foundation
Related Courses
-
Presto 2.0 Benchmark Analysis - Presto C++ and Query Optimizer Results
-
History Based Optimizer - Making Query Plans More Efficient Through Past Executions
-
An Intro to Presto, the Open Source Distributed SQL Query Engine for the Data Lake
-
Quick Stats - Runtime ANALYZE for Better Query Plans
-
Enhancing Presto's Query Performance and Data Management with Hudi - Innovations and Future
-
Building Large-scale Query Operators and Window Functions for Prestissimo using Velox
