Questions tagged [index-rebuild]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-6 votes
1 answer
59 views

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

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 ...
user avatar
  • 2,371
-1 votes
2 answers
27 views

What other than `delete and re-creation of the index` happens when an index is rebuilt which does not happen in the reorganize command?

When an index reorganize command is fired, then it will not drop and re-create the index. However just like a rebuild it will defragment the data and ensure that the physical ordering of the page is ...
user avatar
  • 2,371
2 votes
3 answers
288 views

Constant rebuilding indexes to fix performance - why?

We have a database server (2016 SQL Server), that we have added a step of 'rebuilding indexes' to the deployment process. In decades of working with MS SQL Server at a many companies, I've never ONCE ...
user avatar