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_4

4. Analyzing Query Behavior Using Execution Plans

Grant Fritchey¹  

(1)

Grafton, MA, USA

 

Execution plans are the best window into understanding the choices made by the query optimizer as it attempts to make your query run quickly. Execution plans accurately describe the behaviors of your query, from the types of join operations to the indexes being used, as well as how they are used. Execution plans are absolutely not a measure of performance. That much must be made clear.

This chapter will outline what execution plans are, what they look like, and how you can read ...