yochananrachamim / AzureSQL

132 stars 61 forks source link

Operation cannot be performed resumably on a table with a Clustered Columnstore Index #31

Open MaxNulls opened 1 year ago

MaxNulls commented 1 year ago

Procedure fails when it tries to do rebuild on Clustered Column Store Index:

ALTER INDEX [TableName] REBUILD WITH(ONLINE=ON,MAXDOP=1, RESUMABLE=ON);

Error: Msg 35397, Level 16, State 1, Line 1 alter statement failed because the operation cannot be performed resumably on a table with a columnstore index. Perform the operation without specifying the RESUMABLE option or drop (or disable) the columnstore index before performing the operation using the RESUMABLE option.