Databases · Middle · Question 13 of 75
Which join algorithms can PostgreSQL use?
- ✓Correct answer: Nested loop, hash join and merge join
- 2Left join and right join
- 3Only nested loop
Explanation
Nested loops suit small inputs with an index on the inner side, hash joins suit large unsorted inputs, merge joins suit inputs already sorted on the join key.