Presented by:Sarah Matta
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?", come 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!).