When a user creates an index, all other users are locked out of the table.. The type of lock depends on the type of index:
Creating a clustered index requires an exclusive table lock, locking out all table activity. Since rows in a clustered index are arranged in order by the index key, create clustered index reorders data pages.
Creating a nonclustered index requires a shared table lock, locking out update activity.
