Level 7 - ArchitectScenario-Based Questionsm2 query shape optimization
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.
Schema Context
orders(order_id, customer_id, status, total_amount, created_at)