Query Optimizer Deep Dive

YouTube·PASS Data Community Summit

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.