Looking at the table definition => Runtime Information I see that the table size is 12.8MB and contains it contains 88553 records. After a delta merge the table size is 4.5MB and contains it still contains 88553 records. Also the compression due to storing the data in a columnar table is nicely visible. Forced a delta merge with this sql statement:
Or use the SAP HANA Studio.
Code: Select all
MERGE DELTA OF "EFASHION"."SHOP_FACTS";