partition Parameter Usage

You can use the partition number_of_partitions parameter to change an unpartitioned round-robin table to a round-robin-partitioned table that has a specified number of partitions.

SAP ASE places all existing data in the first partition. The remaining partitions are created empty; they are placed on the same segment as the first existing partition. Data inserted later is distributed among all partitions according to the round-robin strategy.

If a local index is present on the initial partition, SAP ASE builds empty local indexes on the new partitions. If, when you created the table, you declared a segment, SAP ASE places the new partitions on that segment; otherwise, the partitions are placed on the default segment specified at the table and index level.

For example, you can use partition number_of_partitions on the discounts table in pubs2 to create three round-robin partitions:

alter table discounts partition 3

Note: alter table with the partition clause is supported only for the creation of round-robin partitions. It is not supported for the creation of other types of partitions.