Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What is an execution plan? When would you use it? How would you view the execution plan?
What is an execution plan? When would you use it? How would you view the execution plan?
✍: Guest
The Query Analyzer has a feature called Show Execution Plan. This option allows you to view the execution plan used by SQL Server’s 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.
2014-10-13, 1796👍, 0💬
Popular Posts:
How is the MVC design pattern used in Struts framework? In the MVS design pattern, there 3 component...
Example of using Regular Expressions for syntax checking in JavaScript ... var re = new RegExp("^(&a...
When should the register modifier be used? Does it really help? The register modifier hints to the c...
Can you prevent a class from overriding ? If you define a class as “Sealed” in C# and “NotInheritab...
Can an anonymous class be declared as implementing an interface and extending a class? An anonymous ...