Level 10 - MasterOptimization Questionsm5 architecture leadership decision rounds
Optimization: Safer Backfill Rollout Strategy
Choose the safer online migration query strategy and provide final SQL. Query A: UPDATE invoices SET normalized_status = LOWER(status); Query B: UPDATE invoices SET normalized_status = LOWER(status) WHERE normalized_status IS NULL AND invoice_id > :last_id ORDER BY invoice_id LIMIT 5000;
Schema Context
invoices(invoice_id, status, normalized_status, updated_at)