on 07-11-2012 9:04 AM
Hi Experts,
Could you please explain about Merge Delta in HANA.
Give me some example about this
Regards,
Siva
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
There is a nice document that explains the merge delta process, why it is required and how it is done.
Thanks,
Anooj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.