What is Query Execution Plan in SQL ?

Query Execution Plan

The TSQL Query tells SQL Server what you want but does not tell it how to do.
The first thing performed on the submitted query is parsing and optimization.
Now it generates an execution plan.
The Execution plan which generated by query optimizer tells the SQL Engine how to execute the query
This plan is used to troubleshoot any performance issue by a query
The query has logical and physical processing stages, which helps to understand the flow.

What is Query Execution Plan in SQL ? was last modified: October 1st, 2017 by Justin Antony

About Justin Antony


Leave a Reply