Consider a scenario in which you manage a table with millions of rows of sales data partitioned by date. This data is queried frequently—several times per minute—by various applications and users. The primary queries involve aggregating values using the AVG, MAX, and SUM functions, and do not require any joins with other tables. The focus is on computations over the past year of data, although you must retain the full historical data in the base tables. Your goal is to ensure that your query results always reflect the most recent data while minimizing computation costs, maintenance efforts, and query duration. What approach should you take to achieve this?