dot Net Database Question: Download Questions PDF
Explain an execution plan? When would you use it? How would you view the execution plan?
Answer:
The Query Analyzer has a feature called Show Execution Plan. This option allows you to view the execution plan used by SQL Servers Query Optimizer to actually execute the query. This option is available from the Query menu on the main menu of Query Analyzer, and must be turned on before the query is executed. Once the query is executed, the results of the execution plan are displayed in graphical format in a separate window, available from a tab that appears below the query results window on the screen.
Download dot Net Database Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain What is the maximum length of a varchar in SQL Server? | Explain atleast two methods of response object other than Transfer? |