The following assumes MSSQL 2008: This expos the difference between "Display Estimated Execution Plan" which is really something to run when you can't afford to run a query because it is too big, and the much more accurate (as it is not an estimate) "Include Actual Execution Plan" which will include a tab within the query results called "Execution plan" that shows a comparable breakdown of the expense of the various bits of a query. If you have "Include Actual Execution Plan" toggled on when you run a query in SSMS you get the extra tab. The video shows using it by running a bunch of queries that are nearly identical save for some experimental tweaks at once to see how they all vary in bringing back "Display Estimated Execution Plan" flows. You can't use “Display Estimated Execution Plan” in SQL Server Express or SQL Server Compact Edition as best as I can tell, so therein you have to just use "Display Estimated Execution Plan."
No comments:
Post a Comment