TechNet
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
The document is archived and information here might be outdated

Partial Aggregate Showplan Operator

Partial Aggregate is used in parallel plans. It applies an aggregation function to as many input rows as possible so that writing to disk (known as a "spill") is not necessary. Hash Match is the only physical operator (iterator) that implements partition aggregation. Partial Aggregate is a logical operator.

Show:
© 2016 Microsoft