Practice
Learn
← Quit
0 / 0 correct
Databases
Hard
1 of 312
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
Casting is always forbidden
D
The planner ignores WHERE clauses