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

Question

Options

• ASometimes a merge join runs faster than a hash join.
• BA merge join uses memory more efficiently.
• CA merge join requires no optimization.
• DA merge join can spill to disk if the inner table is too large.
• EA merge join joins the data into a new projection.

• A
  4% (2)
• B
  84% (42)
• D
  2% (1)
• E
  10% (5)

Explanation

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

No community discussion yet for this question.