GROUP BY
This statement appears in the showplan output for any query that contains a group by clause. Queries that contain a group by clause are always executed in at least two steps:
One step selects the qualifying rows into a worktable and groups them.
Another step returns the rows from the worktable.
