Code AnalysisBeginner 60s

Missing index on a foreign-key join

Why does this join get slower as tables grow?

Starter code

SELECT u.name, o.total FROM users u JOIN orders o ON o.user_id = u.id WHERE u.id = ?;

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.