Sample Header Ad - 728x90

Does offline index rebuild of clustered or non-clustered index block user's SELECT/UPDATE/INSERT/DELETE queries?

-6 votes
1 answer
246 views
I understand that index rebuild requires schema stability (Sch-S) lock which means it will block any query that tries to do the schema modification (Sch-M). Does an offline index rebuild of clustered or non-clustered index also block user's SELECT/UPDATE/INSERT/DELETE queries?
Asked by variable (3590 rep)
May 17, 2022, 07:08 AM
Last activity: May 18, 2022, 01:40 PM