culuo4781的博客 If we were to clear the execution plan cache and rerun this for a parameter value of 0, then we would get a different plan: 我们可以看到SQLServer使用了对非聚集索引的扫描...
culuo4781的博客 这使我们可以查看执行查询时进行了多少逻辑和物理读取,并且可以通过运行以下TSQL在SQLServer Management Studio中以交互方式打开它: SET STATISTICS IO ON; 将统计信息IO设置为ON; Once on, we will see ...