Finance Certifications Goldman Sachs & Amazon Teams Trust
Lead AI Strategy with UCSB's Agentic AI Program — Microsoft Certified
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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