8. SQL Statements : CREATE INDEX : Locking
 
Share this page                  
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.