Creating indexes affects performance by locking other users out of a table. The type of lock depends on the index type:
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.
