← Quiz: Query Processing and Optimization: all 10 questions
Quiz: Query Processing and Optimization · Question 9 of 10
Which join method builds an in-memory table on the smaller input and probes it with the larger one?
Which join method builds an in-memory table on the smaller input and probes it with the larger one?
- A.Block nested loop
- B.Hash join
- C.Sort-merge join
- D.Index nested loop
Answer & explanation
Correct answer: Hash join
The hash table makes each lookup close to constant time.
Can you get the rest right without peeking?
Take the timed Quiz: Query Processing and Optimization quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →