用SET STATISTICS TIME命令显示T-SQL语句执行时间

aolin02

于 2011-04-05 12:09:46 发布

阅读量139

点赞数

分类专栏： T-SQL 文章标签： SQL SQL Server Go

本文链接：https://blog.csdn.net/aolin02/article/details/83885102

版权

T-SQL 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

下面的示例显示服务器的执行、分析和编译时间。

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.