cancel
Showing results for 
Search instead for 
Did you mean: 

MERGE DELTA in SAP HANA

Former Member
0 Kudos

Hi Experts,

                 Could you please explain about Merge Delta in HANA.

Give me some example about this

Regards,

Siva

Accepted Solutions (1)

Accepted Solutions (1)

former_member184768
Active Contributor
0 Kudos

Hi Sivakumar,

In simple terms, DELTA merge is an operation to move the data from WRITE optimized DELTA memory to READ optimized and Compressed MAIN memory.

This can be done automatically by HANA using Smart Merge technology or manually using MERGE DETLA OF sql statement or using right click option on HANA studio.

You can see check the values in M_CS_COLUMNS view for the memory_size_in_total, memory_size_in_main and memory_size_in_delta BEFORE and AFTER delta merge to see the difference.

Regards,

Ravi

Former Member
0 Kudos

Hi,

     Thanks for your Suggestion. May i know what is the purpose to use  Redeploy and migrate in SAP

HANA.Could give me about some examples.

Regards,

Sivakumar

Answers (2)

Answers (2)

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

Hi,

There is a nice document that explains the merge delta process, why it is required and how it is done.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10681c09-6276-2f10-78b8-986c68efb...

Thanks,

Anooj