SQL语句影响性能查看语句

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