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 » Undocumented » Internals » Top   (RSS)
  • Inside the Optimizer: Row Goals In Depth

    Background One of the core assumptions made by the SQL Server query optimiser’s model is that clients will consume all of the rows produced by a query.  This results in plans that favour the overall execution cost, though it may take longer to begin producing rows.  Let’s look at an example: The optimiser chooses to perform the ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on August 18, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement