Splitting a Partition

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.

  1. 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.
  2. Expand ASE Servers > Schema Objects > Tables, then choose one of:
    • User Tables
    • Proxy Tables
  3. Select the table for which you are splitting a partition.
  4. Select Properties.
  5. Select Partitions.
  6. Specify whether to create a new partition or change an existing partition.
  7. Click the partition and select Split.
  8. Click Next.
  9. 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.
  10. Click OK.