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

[lbreddemann · Accepted solution]

Hello Santosh,

the column store tables are highly read optimized data structures internally.

Unfortunately, these data structures are not so well suited for changing data in them.

To overcome this every column store table has a so called delta log that allows to capture data changes like update, insert and deletes in a very fast manner.

The problem here is just that the delta log in turn is not so well performing during read operations as the main structure is.

So, what's needed here is to get the data from the delta log to the so called main index.

This is what a delta log merge operation does.

The command you mentioned triggers this merge operation for a specific table.

regards,

Lars