Community

Optimization Thresholds – Grouping and Aggregating Data, Part 4

(Itzik Ben-Gan) This article is the fourth in a series about optimization thresholds. The series covers grouping and aggregating data, explaining the different algorithms that SQL Server can use, and the costing model that helps it choose between the algorithms.