Can i alter clustered by column #12121
-
Is there any way to modify clustered by column? or if you can suggest a better way to update the column of clustered by without moving data? |
Beta Was this translation helpful? Give feedback.
Answered by
mfussenegger
Feb 15, 2022
Replies: 1 comment
-
Altering the clustered by column is not possible. It is used for the data distrubtion and changing it would mean that they'd have to redistribute all the data. Currently the best alternative is to create a new table, copy over the data using insert into with a select and then swap around the table with |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
aman00323
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Altering the clustered by column is not possible. It is used for the data distrubtion and changing it would mean that they'd have to redistribute all the data.
Currently the best alternative is to create a new table, copy over the data using insert into with a select and then swap around the table with
alter cluster swap table