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
Last activity: May 18, 2022, 01:40 PM