Explain Execution Plan?

1.	Explain Execution Plan?
Answer» SQL Server caches the plan of execution of query or stored procedure which it uses in SUBSEQUENT call. This is a very important feature with regards to performance ENHANCEMENT. You can view execution plan of data RETRIEVAL graphically or TEXTUALLY.

Answer»

SQL Server caches the plan of execution of query or stored procedure which it uses in SUBSEQUENT call.
This is a very important feature with regards to performance ENHANCEMENT.
You can view execution plan of data RETRIEVAL graphically or TEXTUALLY.

Discussion