SQL执行效率测试

--清空缓存

checkpoint
dbcc freeproccache
dbcc dropcleanbuffers

 

--设置cpu时间

SET STATISTICS io ON
SET STATISTICS time ON
go

 --查询语句

select * from tablename

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