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. Adaptive Server 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, Adaptive Server builds empty local indexes on the new partitions. If, when you created the table, you declared a segment, Adaptive Server 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
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.
