You can enable the
STATISTICS TIME option for individual user sessions. In an SSMS query window, you type the following:
SET STATISTICS TIME ON
You can also set this option for the query session in SSMS by choosing the Options item in the Query menu. In the Query Options dialog, you click the Advanced item and check the
SET STATISTICS TIME check box.
STATISTICS TIME option displays the total CPU and elapsed time that it takes to actually execute a query. The
STATISTICS TIME output for the query in Listing 32.4 returns the output shown in Listing 32.5. (Again, the data rows returned have been deleted to save space.)
set statistics io onset statistics ...