Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6

You are here: SQL Server Objects > Tables > Manage Table Partitions > Partition Tables

Partition Tables

Partitioning a table arranges the data into smaller more manageable pieces. The CPU can perform operations on more than one partition simultaneously, which improves performance. A very large database performs best if the partitions use multiple disks, separate filegroups, and preferably multiple CPUs.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To partition a table

Select Tables from the Databases node in the Object Explorer.
Right-click a table and select Storage | Create Partition.
Complete the wizard.

Tips:

You can right-click a partitioned table and select Storage | option to manage or undo the table partition.
You can right-click a table and select Storage | Unused Objects to remove unused partition schemes and functions.