Skip to content
lectern.tv

Lecture 1: SQL Optimization Background (15-799)

Professor

53:57·2025·graduate level
Path step 4: Establishes declarative query optimization as search over equivalent relational algebra plans.

This lecture establishes fundamental concepts of relational database query optimization, including algebraic transformations and the role of cost-based optimizers in enhancing query performance.

Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)

Slides: https://15799.courses.cs.cmu.edu/spring2025/slides/01-background.pdf

15-799 Special Topics in Database: Query Optimization (Spring 2025)

Carnegie Mellon University

Seminar notes & discussion

No public seminar notes on this lecture yet.