Tuesday, 3 September 2013

Partition scheme change with clustered Index

Partition scheme change with clustered Index

I have table which has 600 million records and also has the Partition on
PS_TRPdate(TRPDate) column, I want to change it to another Partition
PS_LPDate(LPDate).
So I have tried with small amount of data with following steps. 1) Drop
the Primary key Constraints. 2) Adding the New Primary Key Clustered Index
with new Partition PS_LPDate(LPDate).
Is it Feasible with 600 million records? Can anyone guide me for it? and
How does it works with Non Partitioned Tables?
--343

No comments:

Post a Comment