SAP HANA Native Storage Extension with Partition of table EDID4
HowTo:
When a column is loaded, it is copied from persistence into SAP HANA column store memory.
Unloads are table column displacements from column store memory.
In this SAP Note we focus on loads and unloads of columns in column store. Tables in row store are typically loaded during startup and remain in memory permanently.
Hot Data: Used to store very critical data for fast & real-time and analytical processing usually stored in DRAM [dynamic RAM], PMEM [Persistent Memory]
Warm Data: Used to store data that are not frequently used and need not reside continuously in SAP HANA memory. NSE manages this data as an expanded disk. Query performance on warm data might be reduced compared to hot data.
Cold Data: Used to store data that is rarely accessed.
SAP Native Storage Extension [NSE] – SAP HANA Native Storage Extension is HANA’s built-in warm storage solution. By default, in HANA 2.0 SP 04 & in SAP HANA CLOUD NSE is enabled, there is no different action needed aside from implementing correct SQL/DDL declarations.
SAP HANA Native Storage Extension with Partition of table EDID4 Read More »