← Quiz: Indexing: all 10 questions
Quiz: Indexing · Question 5 of 10
Which condition usually PREVENTS using an index on created?
Which condition usually PREVENTS using an index on created?
- A.created = '2026-11-01'
- B.created BETWEEN '2026-01-01' AND '2026-12-31'
- C.YEAR(created) = 2026
- D.created > '2026-01-01'
Answer & explanation
Correct answer: YEAR(created) = 2026
Wrapping the column in a function hides the sorted values from the index.
Can you get the rest right without peeking?
Take the timed Quiz: Indexing quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →