Sap Hana - Delta Merge Operation

About

The Delta Merge Operation is an operation on a table column store data structure.

The purpose of the delta merge operation is to move changes collected in the delta storage to the read-optimized main storage.

After the delta merge operation, the content of the main storage is persisted to disk and its compression recalculated and optimized if necessary.

A further result of the delta merge operation is truncation of the Sap Hana - Table Column - Column Store (ie redo operations)

It is important to understand that even if a column store table is unloaded or partly loaded, the whole table is loaded into memory to perform the delta merge.

During the delta merge operation, every partition of a partitioned table is treated internally as a standalone table with its own data and delta store.

Management

SQL

MERGE DELTA OF '<table_name>' (hard merge)
MERGE DELTA OF '<table_name>' WITH PARAMETERS ('FORCED_MERGE' = 'ON') (forced merge)
MERGE DELTA OF '<table_name>' WITH PARAMETERS ('MEMORY_MERGE' = 'ON') (memory-only merge)

Powered by ComboStrap