Question: what is the difference between actual execution plan and estimated execution plan?
Answer: The estimated execution plan is generated based solely on the statistics that SQL Server has - without actually executing the query. ... The actual execution plan is just that - the actual execution plan that was used when actually running the query.