What is an execution plan? When would you use it? How would you view the execution plan?
An Execution plan is basically presentation of the map in graphically or textually shows of the dat retrival methods whihc is choosen by the SQL Server abd it can be query optimiser for the stored procedure or ad‐hoc query and we can also use this as a tool for a developer to understand the performance characteristics of a query or stored procedure since the plan is the one that SQL Server will place in its cache and use to execute the stored procedure or query. From within Query Analyzer is an option called "Show Execution Plan". If this option is turned on it will display query execution plan in separate window when query is ran again.