Microsoft – SQL Server – Online Index Management
Being able to perform online Index Management is very beneficial.
In one of our use cases needed to find out whether we can change the ordering of one our indexes.
I really should review the usage of the Create Index\DROP_EXISTING command.
Though, I have yet to review it, it supposedly it allows one to change the columns and ordering of an existing index, without having to explictly drop the old one first.
Anyway needed a quick answer as whether we can create a “Clustered Index” Online and it seems we can:
Here are a couple of good references:
1) Adding a PK online – Tibor Karaszi (7th SQL Server MVP in the World)
2) Possible blocking when building an Index Online
1) Warning: Online index operation ‘<index-name>’ will proceed but concurrent access to the table may be limited due to residual lock on the table from a previous operation