Estimated Query Execution Plan Vs Actual Query Execution Plan - SQL Server

Hi,

What are the main differences between "Estimated Query Execution Plan" and "Actual Query Execution Plan" ? Does the "Estimated Query Execution Plan" includes all the rows from result set (Full result set) ?

Thanks
milani_lucieAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Not enough much difference..
Estimated Execution plan is generated once the query is compiled and query plan is added to plan cache..

Actual Execution plan would be generated once the query is run and 99.99% it would take the plan which is cached by Estimated execution plan..
0
 
Rajkumar GsConnect With a Mentor Software EngineerCommented:
This will explain you clearly.

http://www.experts-exchange.com/Q_22648611.html

Raj
0
All Courses

From novice to tech pro — start learning today.