This repository was archived by the owner on Aug 15, 2024. It is now read-only.
Repository navigation
This repository was archived by the owner on Aug 15, 2024. It is now read-only.
Add WITH (ONLINE=ON) to MS SQL indexes creation #554
Description
If we upgrade V2 to V3, we have existing database with millions of record and creating index may be time-consuming.
To anticipate it, Indexes IX_Streams_IdOriginal and IX_Streams_IdOriginalReversed (and other indexes as well) better to specify WITH (ONLINE=ON)
Unfortunately it is required to add conditional logic as not all sql server editions support WITH (ONLINE) https://stackoverflow.com/questions/50407490/how-to-create-nonclustered-index-with-online-if-available
Btw, even WITH (ONLINE=ON) may cause blocks on the final stage
https://dba.stackexchange.com/questions/41181/why-does-create-index-with-online-on-block-access-to-the-table-over-a-period/50139#50139
Activity
michael-freidgeim-webjet commentedon Jun 18, 2022
When I created the index, I got
Does it mean, that MS SQL in reality support not more than 848 characters, not 1000 as declared in schema?
(it's not a problem for my IdOriginal values)