Scenario: Query Shape for Multi-Widget Dashboard

A dashboard runs 8 widgets every minute over orders. Design query-shape strategy to reduce repeated scans while keeping freshness under 2 minutes.

orders(order_id, customer_id, status, total_amount, created_at)