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