'Do I need to alter previous indexes when using partitioning

I've just been partitioned a large table in azure sql server (approx 300 million rows). To do this I created a new partitioning table (identical schema) from the original non-partitioned table, dropped the clustered primary key, made it non-clustered and applied the new clustered index on the partition column, in this case countryid.

Before migrating the data across I dropped the existing indexes from the new table that were carried over as part of the create script. My question is, once the data is fully inserted into the new table am I ok to simply script the old indexes from the original table and re-apply them to the new partitioned table OR do I have to do anything to the scripts before applying them, to take advantage of the fact that they are now being used on a partitioned table?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source