Question
Explain query execution plan?
Answers
- The optimizer available in SQL Server optimizes the code to be effectively executed.
- A query execution plan shows how this optimizer would run the query.
- Query execution plan can be viewed by :
- Using the Show Execution Plan option available in Query Analyzer,
- Displaying Estimated Execution Plan on the query dropdown menu,
- Use the SET SHOWPLAN_TEXT ON command before running a query and capturing the execution plan event in a SQL Server Profiler trace.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q You edit a box to the point where it no longer resembles a box, but a human head. You turn the bounding box back on by pressing "j," and you realize that the reference coordinate system is off, as your bounding box is now covering your new head like a diamond. How do you reset the bounding box?
  • Q Recently, which Bollywood Actor awarded with Padma Vibhushan
  • Q What is Broad money in India?
  • Q Who appeared on the first US postage stamps (both names)
  • Q Which musical featured the song They Called The Wind Mariah?
  • Q Who was the first ruler of Vardhan Dynasty?
  • Q Why would a book of today be called a classic?
  • Q Which type of climate is known for the maximum diurnal range of temperature?
  • Q Which film won Oscar Best Film Award 2017?
  • Q What is third degree price discrimination?
  • Q Give the classification of Nightingale in animal kingdom?