THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Query Plans » Cardinality » Bugs   (RSS)
  • Cardinality Estimation Bug with Lookups

    Estimated row counts on key or RID lookups where a filtering predicate is applied can be wrong in SSMS execution plans.  This error does not affect the optimizer’s ultimate plan selection, but it does look odd.  There are other cases where estimated row counts are inconsistent (for defensible reasons) but the behaviour shown in this post ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on October 15, 2012
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement