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;
SQL Server – SQL Execution plan and SET SHOWPLAN_XML ...
SQL Server Query Optimizer and Statistics
SQL Server – How to troubleshoot a slow running query
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |