Practice
Learn
← Quit
0 / 0 correct
Databases
Hard
1 of 40
Why can WHERE created_at::date = '2026-01-01' fail to use an index on created_at?
A
Applying a function/cast to the indexed column prevents an index range seek; rewrite as a range on created_at or index the expression
B
Dates can't be indexed
C
The planner ignores WHERE clauses
D
Casting is always forbidden