-
MS SQL: Creating Partition to existing table
I have read articles "Data Partitioning in SQL Server 2005 - Part I & II", they are great. Is there any article on how to create partition to existing table?
Thanks
Hannah
-
This article is a series. part III will talk abt this. meanwhile you could check the syntax for dropping index.
drop index MyTable_IXC on MyTable with (Move To [Data Partition Scheme] (ID) )
-
Hi
What if partition key is not a part of a clustered index?
Regards
-
Then table is partitioned by partition key, and data in each partition are physically ordered by clustered index. We found that using clustered index as partition key has better performance.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|