Query analysis is the process of examining the way SQL Server executes a query to identify potential bottlenecks, inefficiencies, or areas for optimization.
The Execution Plan can be generated in SQL Server Management Studio (SSMS) by enabling the 'Include Actual Execution Plan' option before running a query.
[
Collection
]
[
|
...
]