All challenges
Code AnalysisBeginner 60s

Index-killing function on column

Why does this full-scan despite the index?
Starter code
CREATE INDEX idx_created ON orders(created_at);
SELECT * FROM orders
WHERE DATE(created_at) = '2026-01-01';

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.

Play this in a 3-minute battle