What are the steps to partition a non partitioned or existing table?

Question

Sumit Kesarwani · Answer

1-Create a partition function.2-Create a partition scheme.3- Drop the existing clustered index.4-Recreate the clustered index on the partition scheme.

interview

What are the steps to partition a non partitioned or existing table?

Can you answer this question?

1 Answers