Share via


Create Partition Wizard (Welcome Page)

Partitioning a database table improves performance and simplifies maintenance. By splitting a large table into smaller, individual partitions, queries that access only a fraction of the data can run faster because there is less data to scan. Maintenance tasks, such as rebuilding indexes or backing up a table, can run more quickly.

This wizard helps you partition an existing table in your database. With this wizard you can:

  • Select the table column on which you want to partition your table.

  • Select the partition function and partition scheme for your partition.

  • Map your partitions to filegroups and specify range values.

  • Create a script for partitioning the table, run the script immediately, or schedule a job for partitioning the table.

The Welcome page is the first page of the Create Partition Wizard. Displaying this page is optional.

  • Do not show this starting page again
    Skip this page the next time that you start the Create Partition Wizard.