Why Your created_at Index Is Useless for Range Queries

The leftmost-prefix rule, the 57× DATE() penalty, and the wide-selectivity trap. Why your created_at index isn’t working.