Loading And Unloading Column Table Into And From Memory

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

Listing 1


Unload From Memory

Listing 2


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

Listing 3


In this case, the status of the table is changed to PARTIALLY.

Recent Articles