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

Explain what is the use of custom fields in report?

0 Answers  

What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  

What are dml (data manipulation language) statements in ms sql server?

0 Answers  

What is co-related sub query?

0 Answers  

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,

Explain the architecture of ms sql reporting service?

0 Answers  

How do I find the default sql server instance?

0 Answers  

Explain system functions or built-in functions? What are different types of system functions?

0 Answers  

Explain having clause?

0 Answers  

What is efficiency data?

0 Answers  

Difference between connected and disconnected database in .net with sql server?

0 Answers   Infosys,

For more SQL Server Interview Questions Click Here
Categories