Level 5 - SeniorDebugging Questions
Debug: Partition Key Function Prevents Pruning
Interviewer prompt: Partition pruning is not happening. SELECT COUNT(*) FROM events WHERE DATE(event_ts) = DATE '2026-03-01'; Rewrite for pruning-friendly filter.
Interviewer prompt: Partition pruning is not happening. SELECT COUNT(*) FROM events WHERE DATE(event_ts) = DATE '2026-03-01'; Rewrite for pruning-friendly filter.