SELECT ... WHERE date_col >= DATE_SUB(CURRENT_DATE, INTERVAL 10 days); There is a subtlety in the new query that using an always changing value like CURRENT_DATE although we don't need the entire date, just the days, will cause this query to miss the cache all the time. Is this argument still valid? as there is no query cache any more (by default at least)