Optimization: Batch Delete Strategy

Interviewer prompt: Need to delete old logs without long locks. Pick better operational query pattern. Query A: DELETE FROM app_logs WHERE created_at < CURRENT_DATE - INTERVAL '180 day'; Query B: DELETE FROM app_logs WHERE log_id IN (SELECT log_id FROM app_logs WHERE created_at < CURRENT_DATE - INTERVAL '180 day' ORDER BY log_id LIMIT 5000);