Why do the outdated statistics degrade a query performance?

by lukaszwinski   Last Updated May 22, 2018 12:06 PM

Some facts:

1. The outdated statistics cause generating an inaccurate estimated plan. The estimated execution plan is created by Query Optimizer which uses both statistics and the query processor tree.

2. The actual execution plan is created after executing the query. When the stats are stale, the Storage Engine generates its own plan which is different than the estimated one.

The question: Why to bother about outdated stats if SQL Server can create accurate actual execution plan (by Storage Engine) when it finds out that data has been changed? How can the difference between the estimated and actual plan influences the query performance?

Tags : sql-server

Related Questions

creating index on big table(s)

Updated September 03, 2018 18:06 PM

Linked Server Error on SQL Agent Job

Updated March 16, 2016 08:02 AM