Query on SQL Script - HANA Basics

[Former Member]

Hi

While practicing the Tutorial ,I came across below SQL statement,can any body explain what this statement exactly does or any pointers to understand the after effects of execution of the below statement would be helpful.

UPDATE "EFASHION_TUTORIAL"."SHOP_FACTS" MERGE DELTA INDEX

Thanks

Santosh

[Former Member]

Hi Santosh,

If you already load the data into SAP HANA and now you want to update the same table with data then only the change record will merge into the table. More simpler way you can say that merging the updated/delta record into the table.

Regards,

Neha

[Former Member]

Hi,

Excellent explanation provided by Lars :-).

Just to add, Delta merge is also automatically done by the system based on some thresholds settings.

The merge operations always trigger a re-write (of the table) in the main memory.

Regards, Rahul