Skip to Content
Apr 30, 2018 at 01:15 PM

Clarification on LOADING and Dynamic Tiering in HANA


Hi, I am trying to clarify my understanding of LOADING and Dynamic Tiering features in HANA platform,

LOADING: Typically data resides in Memory and also in Hard disk(recovery purpose). In case of insufficient memory, system will UNLOAD tables from memory to free up space. Similarly when required, tables can be loaded into Memory.

Dynamic Tiering: non frequently accessed tables are created as extended tables, only in Disk. They are not available in memory. My query can access these extended tables from disk when requested. however, they do not get loaded into Memory. Can you please confirm that, my understanding is correct on Dynamic Tiering tables never loaded into Memory...