Practice
Learn
← Quit
0 / 0 correct
Databases
Hard
1 of 376
How do you safely backfill a new column on a 500M-row table?
A
Update in small batches by primary key range, with throttling and progress tracking, outside a single huge transaction
B
Drop and reload the table
C
One UPDATE statement for all rows
D
Add a trigger and wait