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.
See Also