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

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
 1557  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.

    3- Drop the existing clustered index.

    4-Recreate the clustered index on the partition scheme.

      Modified On Mar-27-2018 04:05:13 AM

Answer

NEWSLETTER

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