Query Optimization: Don’t Know What to Do? Do What You Know

on YouTube ↗43m

" summary

Covers practical techniques for SQL query optimization: how to diagnose slow queries, read execution plans, and apply concrete fixes like indexing, query rewriting, and statistics updates. Focuses on step-by-step actions developers already know to systematically improve database query performance in .NET applications.

AI-written summary · about

" chapters (7)

1. 0:00Introduction
2. 1:51Binary search for complex queries
3. 6:31Simple query optimization
4. 11:08Table variables vs temp tables
5. 17:37Cursor performance pitfalls
6. 23:03How indexes speed up queries
7. 32:58Hierarchical queries and paths

" related talks

• 20mLevel up your SQL skills as a developerOuissal El Machkouri · BlaBlaConf 2022
• 25mThe Secret Life of SQL: How to Optimize Database PerformanceBryana Knight · RailsConf 2017
• 51mPostgreSQL: Practical Examples of SQL Query OptimizationIvan Frolkov · HighLoad++ 2016
• 53mBanishing Slow Queries with Intelligent Query ProcessingJohn Morehouse · SQLBits 2019
• 05mAfter analyzing 600,000 SQL queries, these are the top mistakes developers makeOded Valin · Yalla DevOps 2021
• 57m5 Essential SQL Skills Every Developer Should KnowMichael Carducci · Great International Developer Summit 2023
• 57mHow modern SQL databases arrive at algorithms you never dreamed ofLukas Eder · W-JAX 2018
• 41mWant to turbocharge your database? Ask me how!Danielle Monteiro · Women Dev Summit 2018