This is a dedicated watch page for a single video.
Scenario: You have a table containing millions of rows of sales data partitioned by date. This data is queried multiple times per minute by various applications and users. The query involves aggregations using AVG, MAX, and SUM over the past year's data, while the full historical data remains in the base table. You want to ensure the query results include the most recent data while minimizing computation cost, maintenance overhead, and query duration. Question: What should you do to optimize the query process?