Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is an execution plan? When would you use it? How would
you view the execution plan?

Question Posted / guest


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

Post New Answer

More SQL Server Interview Questions

Which databases are part of SQL server default installation? Explain the usage of each?

2 Answers   Accenture,

What types of integrity are enforced by a foreign-key constraint

1 Answers  

How to write character string constants or literals in ms sql server?

0 Answers  

Can you leave a union at any time?

0 Answers  

What do you understand by recursive stored procedure?

0 Answers  

What is change data capture (cdc) in sql server 2008?

0 Answers  

What is a functions and types in sql server?

0 Answers  

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

Explain cdc and sql injection?

0 Answers  

Explain sql server service broker?

0 Answers  

What are the disadvantages of using the stored procedures?

0 Answers  

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories