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

View Code 

SET STATISTICS io ON
SET STATISTICS time ON
go

--这里写你的SQL语句

go
SET STATISTICS profile OFF
SET STATISTICS io OFF
SET STATISTICS time OFF

 

posted @ 2012-12-08 16:05  冰封的心  阅读(282)  评论(0)    收藏  举报