用SET STATISTICS TIME命令显示T-SQL语句执行时间
下面的示例显示服务器的执行、分析和编译时间。
USE AdventureWorks; GO SET STATISTICS TIME ON GO SELECT * FROM Production.ProductCostHistory WHERE StandardCost < 500.00; GO SET STATISTICS TIME OFF; GO
?下面是结果集：
?
SQL Server parse and compile time:
?? CPU time = 0 ms, elapsed time = 1 ms.
SQL Server parse and compile time:
?? CPU time = 0 ms, elapsed time = 1 ms.
(269 row(s) affected)
SQL Server Execution Times:
?? CPU time = 0 ms,? elapsed time = 2 ms.
SQL Server parse and compile time:
?? CPU time = 0 ms, elapsed time = 1 ms.
