What is Execution Plan?

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

Hi  Jayachandra ,

 

go through following references