Tag Archives: index Concurrency

Factor which Influence Index Rebuilt Strategy

Choosing options for an index create or rebuild involves deciding whether to do it online or offline, whether to use the temporary space in TEMPDB or in the user database Here is the summary of options for index rebuilding and their effects. ONLINE Concurrency Versioning Time SORT_IN_TEMPDB YES high Yes Slow YES YES high Yes [...]