Loading And Unloading Column Table Into And From Memory
18 October 2017 - 914 views
SAP HANA automatically manages loading and unloading column table into and from memory but there are times you might want to manually do this process. This can be done quickly using the query below. You will need to have the TABLE ADMIN System privilege.
Load Into Memory
Unload From Memory
The status of a loaded table will change to FULL. You can also load a single column or multiple columns as shown in the query below.
Load an Individual Column
1LOAD TABLE_NAME (COLUMN_NAME,...)
In this case, the status of the table is changed to PARTIALLY.