SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
SQL Server execution plan as text

29 September,2010 by Jack Vamvas

Sometimes it's more useful to display the execution plan as text format .
Even though Grapical format is the easiest to read , a lot of the operator data is visible - except by looking into Property windows.

In diagnosing complex execution plans this is where the text format is useful.

To execute the Estimated text execution plan - use:

SET SHOWPLAN_ALL ON;

To turn it off use:

SET SHOWPLAN_ALL;


In order to view the profile information of the Actual execution plan, use:

SET STATISTICS PROFILE ON;

and to turn it off:

SET STATISTICS PROFILE OFF;

Read More

SQL Server – SQL Execution plan and SET SHOWPLAN_XML ...

SQL Server Query Optimizer and Statistics

SQL Server – How to troubleshoot a slow running query


Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer