How modern SQL databases arrive at algorithms you never dreamed of
summary
The talk explains how modern relational SQL databases use cost-based query optimization to execute complex, declarative SQL statements fast — even on tables with billions of rows. It shows that, when developers know SQL, the database optimizer can outperform hand-written algorithms, making SQL a powerful language for implementing business logic.
AI-written summary · about
chapters (6)
- 0:00Welcome
- 3:55SQL developer productivity
- 18:44Window functions
- 29:09Database optimization algorithms
- 48:19SQL as 4G language
- 56:00Summary
related talks
51mHow Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of
50mHow SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of
02h 42mSQL (The Return): Demystifying Preconceptions and Using the DB Effectively
41mModern SQL: Evolution of a dinosaur
47mModern SQL: Evolution of a Dinosaur
01h 00mModern SQL: Evolution of a Dinosaur
20mLevel up your SQL skills as a developer
45mMore Than a Query Language: SQL in the 21st Century