Horizontal Partitioning

Horizontal positioning in MS SQL Server 2005 is a method for making large tables and indexes more manageable by dividing them horizontally and spreading them across more than one filegroup in a database.

PowerDesigner supports horizontal partitioning through the partition function and partition scheme objects.

• Partition Functions
  A partition function specifies how a table or index can be partitioned. PowerDesigner models partition functions as extended objects with a stereotype of <<PartitionFunction>>.
• Partition Schemes
  A partition scheme maps the partitions produced by a partition function to a set of user-defined filegroups. PowerDesigner models partition schemes as extended objects with a stereotype of <<PartitionScheme>>.
• Partitioning a Table or an Index
  To partition a table or an index, specify a partition scheme and column on the Microsoft tab of its property sheet.