Code AnalysisIntermediate 60s

Implicit type cast kills index

A table has an index on user_id (a VARCHAR). Why is this query doing a full scan?

Starter code

SELECT * FROM events WHERE user_id = 12345;

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.