WHAT ARE THE STEPS TO PARTITION A NON PARTITIONED OR EXISTING TABLE?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
 1422  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

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

    1-Create a partition function.

    2-Create a partition scheme.

    3Drop the existing clustered index.

    4-Recreate the clustered index on the partition scheme.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!