Splitting a Partition

Splitting partitions can improve performance 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. Expand ASE Servers > Schema Objects > Tables, then choose one of:
    • User Tables
    • Proxy Tables
  2. Click the Name field of the table, then click the drop-down arrow and select Properties.
  3. In the left pane, click Partitions.
  4. Click the drop-down arrow and select New, or choose to an existing partition from the right pane.
  5. Click the Name field of the partition, then click the drop-down arrow and select Split.
  6. (Optional; only for user tables) Select Enable 'online' mode, which improves concurrency and data availability during the split partition operation
    Enable partition locking must also be enabled.
  7. Click Next.
  8. 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.
  9. Click OK.