Indexes Out the Window

I ran into a peculiarly puzzling situation with a query I have been tuning of late. ┬áThe query runs some aggregations and performs a range scan based on a date value passed to the query. […]