Working with estimated execution plan
Estimated execution plan is the result of query optimizer, it is generated even before the query execution. Hence, it might have some or more changes when compared with the actual execution plan, but in most cases the actual and estimated execution plan remain almost the same.
Getting ready
As a DBA, many times you might come across a situation where you come to the office in the morning, somebody comes to you complaining that one of the page is taking a long time to display data which was working just fine and fast some days back. What would you do in the first step? How do you determine where the problem is?
This is the time where the estimated execution plan comes into picture. You take the query or stored ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
