Improved Concurrency for Partition-Level Online Operations

Certain partition-level operations can concurrently operate on different partitions of a table. DML can also concurrently operate on the table while the partition-level online operation is running.

These include:

alter table … split partition
alter table … merge partition
alter table … move partition
alter table … drop partition
truncate partition
dbcc checkindex
dbcc checktable
dbcc tablealloc
dbcc indexalloc

Partition-Level Online Operation Syntax
To allow for greater data availability, alter table and truncate partition commands include the with online subclause in the partition clause.
Concurrency with Partition-Level Online Operations
Multiple partition-level online operations can be executed concurrently on different partitions of a table.
Partition-Level Online Operations with Global Index
Concurrent DML access to a table does not use global indexes while a partition-level operation is in progress on the table. SAP ASE uses alternate local index scan or table scan for concurrent DML scans.

Parent topic: Partition Tables and Indexes