devxlogo

Obtaining Actual & Estimated Execution Plans for SQL Queries

Why Trust Us

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 ONGOSELECT * FROM TableName WHERE Field = ValueGOSet SHOWPLAN_XML OFFGO-- Get Actual Execution PlanSET STATISTICS XML ONGOSELECT * FROM TableName WHERE Field = ValueSET STATISTICS XML OFFGO

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

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.

Disclosure

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

Show More