SQL Server中如何查看SQL语句的执行时间

Posted on 2013-07-18 13:45 FryFish 阅读(359) 评论(0) 收藏举报

通过设置如下参数，在执行完SQL语句后，在执行结果中将显示相应的时间：

set statistics profile on
set statistics io on
set statistics time on
go

<...SQL语句...>

go
set statistics profile off
set statistics io off
set statistics time off