What are the advantages of a merge join versus a hash join? (Select two.)

A.
Sometimes a merge join runs faster than a hash join.

B.
A merge join uses memory more efficiently.

C.
A merge join requires no optimization.

D.
A merge join can spill to disk if the inner table is too large.

E.
A merge join joins the data into a new projection.

Explanation:
https://my.vertica.com/docs/6.1.x/HTML/index.htm#20001.htm