Abstract
There are number of tools available to investigate an optimizer—namely, query analyzer, the graphical query execution plan, and the SQL Server Profiler. This chapter focuses on the graphical query execution plan. It describes the SET statements and options available. The chapter examines the graphical interface in SQL Server 2005, which is a known part of the SQL Server Management Studio. The SET SHOWPLAN and SET STATISTICS commands are used for examining query plans and execution details of a query. There is distinct difference between the SHOWPLAN and STATISTICS options. SHOWPLAN describes how the optimizer intends to execute a query. The STATISTICS performs the query and then returns information about how the query is executed. Thus, SHOWPLAN estimates before query execution, and STATISTICS provides a picture of query execution, after execution of the query has been completed. The text of the query is repeated and then information pertaining to the query execution plan is displayed.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callMore From: Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
