nested loop, merge scan, and hash join — each have scenarios where they excel and scenarios where they struggle. The EXPLAIN output tells you which was chosen and helps you determine whether it was the right choice.