DBCC DROPclreanbuffers
--IO情况查看
SET statistics IO ON
select * from dbo.ProductInfo
SET statistics IO OFF
--执行时间查看
SET statistics TIME ON
select * from dbo.ProductInfo
SET statistics TIME OFF
转载于:https://www.cnblogs.com/0000/archive/2009/07/03/1516245.html