What Method Works Best

Harbr's BI team runs the same five aggregation queries every morning against logistics.shipments — total credits by region, carrier share by month, average delivery_days by warehouse, and two more. Each query scans 200 million rows and takes around 60 seconds on a Medium warehouse. Clustering on region and dispatch_date is already in place and the Query Profile confirms pruning is working. The underlying data updates once per day via a nightly COPY INTO load.

The team wants sub-second dashboard response without upsizing the warehouse. Which optimization method is the best fit?