GROUP BY Paths

A GROUP BY operation has two algorithms:

If possible, the query optimizer chooses the faster algorithm GROUPBY PIPELINED over GROUPBY HASH.

Note: For details, see GROUP BY Implementation Options in Analyzing Data.