Code AnalysisIntermediate 50s

Trace: Index Usage

SELECT * FROM t WHERE lower(email) = 'a@b.com' with an index on email:

Starter code

CREATE INDEX idx ON t(email);
SELECT * FROM t WHERE lower(email)='a@b.com';

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.