LOGGED batches
Coordinator writes to system.batches. Ensures all-or-nothing across partitions. Expensive coordinator load. Rare valid use.
Advertisement
UNLOGGED batches
Efficient when all statements share partition key. Atomic per replica. Standard for multi-row-single-partition writes.
Advertisement
Anti-pattern
LOGGED batch across many partitions to 'be safe'. Massive coordinator + replica load. Common mistake.