Skip to main content

Partial Aggregate

Short Description

Partial Aggregate applies aggregation to as many rows as possible to avoid spill. It is used in parallel plans.

Detailed Description

To avoid spilling to disc and therefore slowing the query down, Partial Aggregate operates on as many rows as it can and still avoiding writing to disc. It is used in parallel plans and can be found being used by a Hash Match.

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.

DBmarlin Trial