I have a database with over 4 million records and i want to select current month records without doing a full table scan.

I created date index on the database but the performance is still very slow

```
SELECT sum(scores) as total
FROM customers 
WHERE YEAR(date_created) = YEAR(CURDATE())
      AND MONTH(cam_date) = MONTH(CURDATE());

```

The code works but takes time to load