Skip to content
Tradeoff Gym
Home
Learn
Lab
Quiz
Stats
← Indexing — why queries are fast or slow
Quiz: Indexing — why queries are fast or slow
Indexing — why queries are fast or slow · 1 of 4
Composite index on (user_id, created_at). Which query can NOT use it well?
WHERE user_id = 5
WHERE user_id = 5 AND created_at > X
WHERE created_at > X only
ORDER BY created_at for user 5