SQLServer查询执行计划分析.docxVIP

看懂执行计划例子1以AdventureWorks的DatabaseLog查询为例：SELECT*FROM[AdventureWorks2008R2].[dbo].[DatabaseLog]?Cached plan size – how much memory the plan generated bythis query will take up in stored procedure cache. This is auseful number when investigating cache performance issuesbecause youll be able to see which plans are taking up morememory.?Estimated Operator Cost – weve already seen this as thepercentage cost in Figure 1.?Estimated Subtree Cost – tells us the accumulated optimizercost assigned to this step and all previous steps, but rememberto read from right to left. This number is meaningless in t