How the Database Joins
Talk it through with a coach who asks guiding questions and gives hints until you reach the answer. Pass to mark the challenge as completed.
The problem
- hard
- Pro
A query plan shows a hash join for one query and a nested loop join for another. Explain how nested loop, hash and merge joins work, and when a database tends to choose each.
Talk this problem through with an AI coach
This is a Pro challenge. Sign in with Google, then upgrade to start a voice session.