DeepFrontend
Learning Paths
Practice
System Design & DS
Design Studio
Data Structures Curriculum
Real-World Case Studies
Careers
Job Board
Resume Builder
Blog
Sign in
Search
⌘K
Go Pro
Loading compiler resources...
Databases Quiz Practice
Active Recall Drill Session
← Exit Session
Question 1 of 1
medium
Databases
Why does writing `WHERE YEAR(created_at) = 2026` fail to utilize a standard index built on `created_at`?
A
Because Year calculations are slow
B
Because applying functions to index columns prevents the planner from utilizing B-Tree value lookups unless an expression index is built
C
Because SQL does not support Year functions
D
Because timestamps are floating point numbers
Check Answer