Scenario: Hotfix for Blocking DDL

Interviewer prompt: ALTER TABLE on orders caused lock contention in production. What SQL strategy should be used next deploy to reduce blocking?

orders(order_id, status, updated_at)