The official PASS Blog is where you’ll find the latest blog posts from PASS community members and the PASS Board. Contributors share their thoughts and discuss a wide variety of topics spanning PASS and the data community.

Re-thinking Types of Execution Plans

A recent discussion on Twitter about the different types of execution plans - specifically estimated vs. actual - got me thinking about how we “define” plans in SQL Server, and I realized we really need one more type of plan. The estimated plan definition needs to be further refined. Rather than two types of plans, I propose we think about plans as one of three types:

  • The estimated plan 
  • The used plan
  • The actual plan

Let me explain…

Read more

RSS
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids