Tech interview questions | Database
The
orders table has ~50 million rows. You need to add a new column is_gift with a default value of false.A developer ran the migration, and after 10 seconds the entire service stopped responding, even for reading orders. The migration process had to be killed.
How should this migration be done correctly?
