MSSQL如何查看SQL语句的执行时间(判断SQL语句的效率)

2014-11-24 14:48:26 · 作者: · 浏览: 0

MSSQL如何查看SQL语句的执行时间(判断SQL语句的效率)
SET STATISTICS io ON
SET STATISTICS time ON
go
www.2cto.com
--这里写你的SQL语句
go
SET STATISTICS profile OFF
SET STATISTICS io OFF
SET STATISTICS time OFF