medium10 pts · first answer countssqlindexingdatabase-performance

Composite index column order

A multi-tenant app adds CREATE INDEX ON tickets (tenant_id, created_at). Which query is this index best suited for?

A.SELECT * FROM tickets WHERE created_at > now() - interval '1 day'B.SELECT * FROM tickets WHERE tenant_id = $1 ORDER BY created_at DESC LIMIT 20C.SELECT * FROM tickets WHERE lower(subject) = $1D.SELECT * FROM tickets WHERE status = 'open'

← Moving credits between accounts Search shows results for old input →