Which scenario correctly demonstrates when a HASH JOIN is preferred over a MERGE JOIN?

SQL Data Analyst Hard

SQL Data Analyst — Hard

Which scenario correctly demonstrates when a HASH JOIN is preferred over a MERGE JOIN?

Key points

  • HASH JOIN is used when sorting is not feasible due to large table sizes.
  • MERGE JOIN requires both input tables to be sorted on the join key.
  • HASH JOIN is more suitable for unsorted tables with large data volumes.

Ready to go further?

Start full exam Practice more questions

Related questions