Recreate the new partition Function and Schemes
and then drop the existing clustered index on the table and move the table to new partition. Sample T-SQL
DROP INDEX IDX_YearWiseSales
ON MyYearWiseSales
WITH (MOVE TO MyMoneyScheme(SaleAmount))
Where MyMoneyScheme is the new Partition scheme.
No comments:
Post a Comment