Horizontal Partitioning (SQL Server)

MS SQL Server 2005 and higher supports horizontal partitioning, 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.

To partition a table or an index, specify a partition scheme and column on the Microsoft tab of its property sheet.

• Partition Functions (SQL Server)
  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 (SQL Server)
  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>>.