http://www.sqlservercentral.com/blogs/scarydba/2009/09/22/gila-monster-on-estimated-vs.-actual-row-counts/

Printed 2014/11/28 01:45AM

Gila Monster on Estimated vs. Actual Row Counts

By Grant Fritchey, 2009/09/22


I don’t generally do lots of blog aggregation and cross post linking & stuff. It’s just not something I’m that into. However, this time is an exception. Gail Shaw, Gila Monster to those who hang on out SQL Server Central, has posted an excellent explanation of times when Estimated and Actual row counts vary for a reason. I’m one of those who emphasises that differences between estimated & actual is an indication of… something. It could be out of date or missing statistics or it could be caused by query language like multi-statement table valued functions, but it’s usually and indication of a problem. Except when it’s not. Read Gail’s explanation for more.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.