Data Management

Hot-Warm-Cold Storages

“Page loadable” means data in NSE (Warm store) and “Column loadable” means data in the main memory (Hot store).

“Page loadable” can be specified at table level, index level, partition level, and Column level.

Data may be converted between “page loadable” to “column loadable” or Vice-versa.

Load units: Loading behavior is determined by a load unit set for Column, Index, Partition, and Table. PAGE (Warm store): On NSE storage disk. COLUMN (Hot store): In main memory DEFAULT(Depends): If you do not specify a load unit for a given granularity, the LOAD_UNIT column in the system views shows the load unit as DEFAULT.