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 » Internals » Aggregates » Row Goal   (RSS)
  • Row Goals and Grouping

    You might recall (from my last post) that query plans containing a row goal tend to favour nested loops or merge join over hashing.  This is because a hash join has to fully process its build input (to populate its hash table) before it can start probing for matches from its second input.  Hash join therefore has a high start-up cost, ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on August 22, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement