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;