July 6, 2009 at 9:28 pm
I have a large table (with 44 million records) in which the primary key is clustered. Now I would like to make the primary key non-clustered and add a clustered index based on another field.
Wonder what is the best way to achieve this with minimum or no downtime.
Any help is appreciated.
Thanks.
July 7, 2009 at 8:06 am
What I have seen recommended in this case is to create a second table and load the data into it, then drop the source table and rename the new table to the original name.
With schemas you could even create the new table with the same name in a different schema, load it, drop or move the source table and transfer the new table into the original schema.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply