Was this helpful?
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.
Last modified date: 01/30/2023