Hello,
In which scenarios can SAP HANA Delta Merges be useful to reduce or disable auto merges?
Thanks in advance.
Updated May 18, 2018
Hello,
In which scenarios can SAP HANA Delta Merges be useful to reduce or disable auto merges?
Thanks in advance.
Comments
Disabling auto merges is mainly useful in scenarios of mass changes, e.g. data loads (many INSERTs) or archiving (many DELETEs). Several standard functionalities already work in this way:
The effect of reducing or disabling auto merges depends on several factors like the COMMIT frequency and the actual DML activities. Furthermore it is a trade-off between performance and memory consumption. The fewer merges are done, the larger is the memory requirement. Therefore a general rule of thumb is not available and you have to test the different options if you perform time-critical mass changes.