what is query execution plan

A query plan (or query execution plan) is an ordered set of steps used to access data in a SQL relational database management system. This is a specific case of the relational model concept of access plans.

 

Pramod for more details please once go through below link:

 

https://www.simple-talk.com/sql/performance/execution-plan-basics/

 

 

 

 

 

 

 

If this is helpful for you then please accept my Answer.