Create Clustered Indexes on Views WITH (ONLINE=ON) - by Michael J. Swart

Status : 

 


7
0
Sign in
to vote
ID 1463070 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 6/23/2015 6:39:19 AM
Access Restriction Public

Description

I would like the ability to create the initial unique clustered index on a view as an online index operation.
With the restriction in place, we can't introduce indexed views when the database has high availability requirements and when that view's base tables are large. In these circumstances, the creation of the indexed view would prevent modifications to base tables for an unacceptably long amount of time.
Sign in to post a comment.