Create and Manage Partitions

The sp_configure option enable semantic paritioning turns on semantic paritioning. Round-robin partitioning is always available, and is unaffected by the value of enable semantic partitioning.

sp_configure ‘enable semantic partitioning’, 1

• Partitioning Tasks
  Before you partition a table or index, you must prepare the disk devices and the segments or other storages devices that you will use for the partitions.
• Create a Range-Partitioned Table
  For best performance, each partition of a range-partitioned table resides on a separate segment.
• Create a Hash-Partitioned Table
  With hash partitioning, all rows are guaranteed to belong to some partition. There is no possibility that inserts and updates will fail to find a partition, which is not the case for range- or list-partitioned tables.
• Create a List-Partitioned Table
  List partitioning controls how individual rows map to specific partitions. List partitions are not ordered and are useful for low cardinality values. Each partition value list must have at least one value, and no value can appear in more than one list.
• Create a Round-Robin–Partitioned Table
  This partitioning strategy is random as no partitioning criteria are used. Round-robin-partitioned tables have no partition keys.
• Create Partitioned Indexes
  Indexes can be created in serial or parallel mode, however, you can create global indexes on round-robin-partitioned tables only in parallel mode.
• Create a Partitioned Table From an Existing Table
  To create a partitioned table from an existing table, use the select into command.