Hi Ravi,
You can use CREATE INDEX with CONCURRENTLY keyword. It will not lock your table during the process.
Best regards.
İyi çalışmalar.
Samed YILDIRIM
19.08.2016, 00:01, "Ravi Tammineni" <rtammineni@xxxxxxxxxxxxxxxxxxxxx>:
I have to create a primary key on a large table (~100Million records). What is the best and fastest way to create pkey? This column is a sequence column and i don't want to lock the table because this is highly transactional database.
Thanks
ravi
