Optimization Showdown: Chunked Backfill vs Single Massive Update

Choose safer production approach. Query A: UPDATE users SET status='ACTIVE' WHERE last_login >= CURRENT_DATE - INTERVAL '30 day'; Query B: Run chunked updates in primary-key ranges with commit checkpoints and monitoring.