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 » Performance » Trace Flags   (RSS)
  • SQL Server 2019 Aggregate Splitting

    The SQL Server 2019 query optimizer has a new trick available to improve the performance of large aggregations. The new exploration abilities are encoded in two new closely-related optimizer rules: GbAggSplitToRanges SelOnGbAggSplitToRanges The extended event query_optimizer_batch_mode_agg_split is provided to track when this new ...
    Posted to Page Free Space (Weblog) by Paul White on August 3, 2020
Privacy Statement