Query Optimizer Deep Dive
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
Delve into the intricacies of query optimization in this advanced-level conference talk presented by Paul White from SQL Kiwi Limited. Explore the inner workings of database query optimizers, gaining insights into their decision-making processes and learning techniques to improve query performance. Discover strategies for analyzing execution plans, identifying bottlenecks, and fine-tuning SQL statements for optimal efficiency. Enhance your understanding of cost-based optimization, statistics management, and index selection to write more effective queries and troubleshoot complex performance issues in database systems.
Syllabus
Query Optimizer Deep Dive (AD)
Taught by
PASS Data Community Summit
Related Courses
Doing More with Less - The Challenges Ahead for Every Data ProfessionalPASS Data Community Summit via YouTube Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube Transform Your Data Estate
PASS Data Community Summit via YouTube Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube