• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 87
  • Last Modified:

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
0
enrique_aeo
Asked:
enrique_aeo
2 Solutions
 
Guy Hengel [angelIII / a3]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
 
Vitor MontalvãoMSSQL 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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now