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 » Uniqueness » Transformations   (RSS)
  • Pulling Group By Above a Join

    One of the transformations available to the SQL Server query optimizer is pulling a logical Group By (and any associated aggregates) above a Join. Visually, this means transforming a tree of logical operations from: …to this: The above diagrams are logical representations. They need to be implemented as physical operators to appear in an ...
    Posted to Page Free Space (Weblog) by Paul White on August 3, 2020
Privacy Statement