db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Join kinds

Postgres has three join algorithms: Nested Loop, Hash Join and Merge Join. The enable_* settings switch algorithms off so you can see the alternatives.

task

Use enable_* settings so SELECT count(*) FROM orders o JOIN customers c USING (customer_id) uses a Merge Join.

hints