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:
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;