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: 08/28/2024