3. Statements : OpenROAD SQL Statements : Create Index Statement : Create Index Locking
 
Share this page                  
Create Index Locking
Creating an index on a table requires an exclusive lock on the table. This lock prevents other sessions, even those using the readlock=NOLOCK option, from accessing the table until create index completes and the transaction containing it is completed.