Optimization Showdown: Raw Fact vs Aggregate Table

Choose better query path for hourly executive KPI dashboard. Query A: Compute KPIs directly from 8B-row raw fact table every refresh. Query B: Use incrementally refreshed aggregate table at hour grain and query that for dashboard.