What is an execution plan? When would you use it? How would
you view the execution plan?
Answer / sumit
An execution plan is basically a road map that graphically
or textually shows the data retrieval methods chosen by the
SQL Server query optimizer for a stored procedure or ad-hoc
query and is a very useful 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" (located on the Query drop-
down menu). If this option is turned on it will display
query execution plan in separate window when query is ran
again.
Is This Answer Correct ? | 3 Yes | 0 No |
Is it possible to create tables in stored procedures using a variable for the table name?
What are 3 ways to get a count of the number of records in a table?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
Normalization and denormalization
What is Data model and how to prepare a data model.?
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?
2 Answers Accenture, Merrill Lynch, Wipro,
What are the components of dbms?
Advantages and disadvantages of stored procedures.
system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??
How to apply cascading referential integrity in place of triggers?
How to check parameter value in stored procedure sql server?
What is the user of Primary key?