dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: SQL
Expertise: Intermediate
May 4, 2016

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Obtaining Actual & Estimated Execution Plans for SQL Queries

Ever wondered if you could determine how the SQL Statements will be executed?

Well, now you can in two ways:

  1. Getting this information whilst not running any queries with SET SHOWPLAN_XML
  2. Getting this information whilst running all queries with SET STATISTICS XML

Here is a small example of each:

-- Gets Estimated Execution Plan Without Executing the Query(ies)
SET SHOWPLAN_XML ON
GO
SELECT * FROM TableName WHERE Field = Value
GO
Set SHOWPLAN_XML OFF
GO
-- Get Actual Execution Plan
SET STATISTICS XML ON
GO
SELECT * FROM TableName WHERE Field = Value
SET STATISTICS XML OFF
GO

The details will be returned in the form of an XML file containing all the information such as memory usage, etc.

Hannes du Preez
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date