What are the advantages of a group by pipe versus a group by hash? (Select two.)

A.
A group by pipe uses memory more efficiently.

B.
A group by pipe can be processed spill to disk if the join result is large.

C.
A group by pipe is at least as fast as a group by hash.

D.
A group by pipe requires no optimization.

E.
A group by pipe builds its entire output table in memory.

Explanation: