What is Execution Plan?

Question

What is Execution Plan and what is the execution plan for a stored procedure? can any one explain with an example?

Prasham Sabadra · Answer

Hi Please have a look at following links http://blogs.technet.com/b/beatrice_popa/archive/2013/05/10/execution-plan-for-stored-procedures-chosen-by-sql-server-database-engine.aspx https://technet.microsoft.com/en-us/library/ms178071%28v=sql.105%29.aspx

Ravi Patel · Answer

Hi Jayachandra  go through following references http://www.sqlshack.com/sql-server-query-execution-plans-viewing-plans/ https://www.simple-talk.com/sql/performance/execution-plan-basics/