Microsoft® SQL Server® 2008 Administrator's Pocket Consultant

Creating Partitioned Tables and Indexes

You create partitioned tables and indexes using a multistep process that requires the following actions:

1. Creating a partition function to specify how a table or index that uses the function can be partitioned

2. Creating a partition scheme to specify the placement of the partitions within filegroups

3. Creating tables or indexes using the partition scheme

I discuss each of these processes in the sections that follow.

Creating Partition Functions

You use a partition function to specify how a table or index is partitioned. The function maps to a set of partitions. To create a partition function, you specify the number of partitions, the partitioning column, and the range of partition column values for each partition. ...