Level 10 - MasterDebugging Questionsm4 platform performance capacity strategy
Debug Partition Pruning Miss
Fix this query to restore partition pruning: SELECT tenant_id, SUM(amount) FROM billing_events WHERE DATE(event_time) BETWEEN DATE '2026-03-01' AND DATE '2026-03-31' GROUP BY tenant_id;
Schema Context
billing_events(tenant_id, amount, event_time) partitioned by event_time