Actual vs. Estimated Execution Plans

Hi Experts
in which case I use:
Actual Execution Plans
or
Estimated Execution Plans

Why Not always possible to get an Estimated plan
enrique_aeoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
I only use Estimated Execution Plan when I know that the query will take long to run so I won't need to wait several minutes for having the Execution Plan. Otherwise Actual Execution Plan should be used by the reasons mentioned by Guy Hengel.
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
the difference is that the estimated execution plan is without considering the current server load, as that might influence the execution plan when the sql is actually run.
I have not seen the situation where I could not get the estimated plan except for statements where this is not possible in either case (DDL statements)... do you have some example to reproduce?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.