Solved

Actual vs. Estimated Execution Plans

Posted on 2014-12-04
2
82 Views
Last Modified: 2014-12-24
Hi Experts
in which case I use:
Actual Execution Plans
or
Estimated Execution Plans

Why Not always possible to get an Estimated plan
0
Comment
Question by:enrique_aeo
2 Comments
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 250 total points
ID: 40480358
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
 
LVL 49

Accepted Solution

by:
Vitor Montalvão earned 250 total points
ID: 40480418
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question