SQL Server Performance

"Select" query blocking "alter index rebuild online"?

Discussion in 'ALL SQL SERVER QUESTIONS' started by Bpr, Nov 29, 2012.

  1. Bpr New Member

    We have a process that rebuilds indexes using "alter index rebuild online". However, if there is an existing "select" query running, it blocks the "alter index". Why is this happening even though we are using the "online" option?
  2. FrankKalis Moderator

Share This Page