How SQL Optimizers Rewrite and Plan Queries
Devoxx · Talk · 51 min · 2017 · YouTube title: How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of by Lukas Eder
Why it's here
HN commenters recommend it to developers unfamiliar with how much leverage and intelligence there is in a SQL database.
What it covers
Lukas Eder's Devoxx talk on how modern cost-based SQL optimizers rewrite and plan queries in ways developers would not expect. It argues that declarative SQL, used well, can run complex queries very fast.