Adaptive Server versions 15.7 ESD #2 and later allows you to split partitions, which
may result in a performance improvement on partitions that include frequent queries and
updates.
- You must set the select into/bulkcopy/pllsort database option
to true before you split a partition.
- You may split only list and range partitions.
See the Transact-SQL Users Guide for information about partitions.
- In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
- Expand , then choose one of:
- Select the table for which you are splitting a partition.
- Select Properties.
- Select Partitions.
- Specify whether to create a new partition or change an existing partition.
- Click the partition and select Split.
- Click Next.
- On the Partition Specification screen, click Add and enter
the.
- Partition name.
- (Optional) Segment name.
- (Optional) Column name. SCC displays the partition key, which is based on the
table that has been partitioned. Enter a new value (or partition condition) for
the split operation.
- Value.
- Click OK.