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