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.