Practice
Learn
← Quit
0 / 0 correct
Databases
Hard
1 of 212
How do you add an index to a large production Postgres table without blocking writes?
A
Lock the table first
B
CREATE INDEX CONCURRENTLY
C
CREATE INDEX inside a transaction
D
Drop and recreate the table