Community

Optimization Thresholds – Grouping and Aggregating Data, Part 1

(Itzik Ben-Gan) An important part of query tuning is understanding the algorithms that are available to the optimizer to handle various query constructs, e.g., filtering, joining, grouping and aggregating, and how they scale. This knowledge helps you prepare an optimal physical environment for your