Implementation and optimization of grouping with DB2® Multisystem

The implementation method for grouping in queries that use distributed files is dependent on whether the partitioning key is included in the grouping criteria.

Grouping is implemented using either one-step grouping or two-step grouping.