26 performance tuning questions and solutions, Actual execution plan, estimated execution plan, Estimated Execution Plan or Actual Execution Plan?, Execution plan in SQL Server, How to tune SQL queries, Interview questions for SQL Server Performance Tuning, Looking for SQL Optimization Interview Questions, performance sql server, Performance tips for faster SQL queries, Performance Tuning, Performance Tuning for SQL Server, Query Optimization, Query Performance Tuning, SQL Complex Queries, SQL Interview questions SQL questions SQL SERVER Interview questions SQL SERVER Interview questions Download SQL SERVER Interview questions Free Download SQL SERVER Interview questions SQL SERVER Tips, SQL Optimization Interview Questions, sql performance, sql performance and tuning, sql performance explained pdf, sql performance tips, SQL Performance Tuning, sql performance tuning and optimization, sql performance tuning interview questions, sql performance tuning tips, SQL Query Optimizer, SQL Query Tuning or Query Optimization, SQL SERVER Interview questions, SQL server optimization interview questions and answers, sql server performance query, sql server performance slow, SQL Server Performance Tuning, SQL Server Performance Tuning Tips, SQL Tuning Overview, Tips for SQL Database Tuning and Performance, Top 10 performance tuning tips for relational databases, What is Query Optimizer?
Estimated Execution Plan or Actual Execution Plan?
Let’s go through some of the differences given below-
|Estimated Execution Plan||Actual Execution Plan|
|In this case you will not observe results tab.||In this case you will observe results tab.|
|They are good for long running queries.||They are not useful if your query is taking too much of time. Although we can run our queries for hours but that will kill out your time. So it depends on you which one to choose i.e. actual or estimated. In most of the case people use estimated if the query is taking too long time.|
|They are created without running the queries.||They are created when actual query runs.|
|They use statistics to get execution plan. Means they are based on statistical understanding of data. May not be correct every time. For example multi valued table variable will always give you 1 as the estimated number of rows. In 2014 they have upgraded it to 100 rows. They may produce bad plans if the statistics are not up to date.||They are created using real data.|
Example of Estimated Execution Plan-
Example of Actual Execution Plan-