SET STATISTICS IO ON; 开启性能查询
SELECT count(1) from StatePullTask where ServiceProvider='YD' and ProviderSequence='ss10010'
SET STATISTICS IO OFF;关闭性能查询
执行计划中有多少次获取表(Scan count);
多少次读取缓存(logical reads);
多少次读取硬盘(physical reads 俺的read-ahead reads);
多少次读取大的对象(lob physical reads , log read-ahead reads);