Optimization Showdown: Retention Job Shape

Choose better retention approach. Query A: DELETE FROM events WHERE event_time < CURRENT_DATE - INTERVAL '180 day'; Query B: Drop/detach monthly partitions older than retention window.