Thursday, July 11, 2013

Display Estimated Execution Plan

...is an icon one may click in MSSQL Server Management Studio after having run a query to see some graphical analysis of a flow for the query which will show offs where the chokepoints in terms of percentages of time spent for the query are. Hopefully this helps you optimize a query. I don't really understand it yet. Percentages may vary from environment to enviroment and the flow itself may look wildly different run against SQL Server Compact Edition in lieu of SQL Server. I am still trying to understand it.

No comments:

Post a Comment