SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

G. FritcheySQL Server 2022 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-8891-7_2

2. Execution Plan Generation and the Query Optimizer

Grant Fritchey¹  

(1)

Grafton, MA, USA

 

All performance within SQL Server starts, and frequently ends, with the query optimizer. Because the optimizer is so important to query performance, we’re diving immediately into how the optimizer behaves in order to better understand why our queries behave the way they do. The optimization process results in an execution plan, a mechanism for showing the choices the optimizer made. The optimization process is expensive in terms of resources, especially CPU, and can be somewhat ...