Quiz
Indexing Join Columns for Performance
Understand which columns to index to speed up a join between two tables.
You have a slow query: SELECT * FROM orders o JOIN customers c ON o.customer_id = c.id WHERE c.country = 'US'. customers.id is already the primary key. Which additional index will most likely improve the join performance?