Level 7 - ArchitectOptimization Questionsm3 partitioning lifecycle
Optimization Showdown: Partition-Prunable Predicate
Pick better query and provide final SQL for monthly-partitioned table. Query A: SELECT COUNT(*) FROM payments WHERE DATE_TRUNC('month', paid_at) = DATE '2025-01-01'; Query B: SELECT COUNT(*) FROM payments WHERE paid_at >= DATE '2025-01-01' AND paid_at < DATE '2025-02-01';
Schema Context
payments(payment_id, paid_at, amount) -- partitioned by paid_at month