I'm wondering if it's possible to compose and deliver a successful tech conference session on multiple databases. What do you think?
Everything You Ever Wondered About SQL Performance: Deep Dive
This is not your typical SQL tuning talk. We’re deep diving --> beyond basic indexing tips --> into how modern relational databases actually parse, plan, and execute your queries.
- Do you know how SQL is parsed?
- Why does the optimizer sometimes pick the “wrong” plan?
Along the way we'll stumble upon subtle ways things can go wrong!
- How can correlated subqueries sabotage execution?
- When do query rewrites go sideways?
From PostgreSQL's bitmap scans to SQL Server's parallelism quirks to MySQL's index merge madness - learn to spot performance killers and know exactly which optimization lever to pull.
If you've ever stared at a slow query wondering "what exactly is the database doing right now?" - find the answer in this talk. Packed with example code, edge cases, and real-world pathologies, it’s everything you’ve ever wanted to know about SQL performance (and probably a few things you didn’t - but should!).
You'll walk away knowing exactly what to do when a query runs slow. Instead of randomly adding indexes and hoping for the best, you'll systematically diagnose performance problems by reading execution plans like a roadmap to the bottleneck. You'll recognize optimizer mistakes, know when a table scan is actually faster than an index, and understand why that "helpful" CTE is secretly destroying your performance.
Most importantly, you'll think like the database itself. Predict which queries will be fast, which will be disasters, and how to rewrite the disasters into successes. No more mystery, no more guesswork, just the confidence that comes from understanding what's actually happening under the hood.