Loading And Unloading Column Table Into And From Memory

18 October 2017 - 958 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

Listing 1

LOAD TABLE_NAME

Unload From Memory

Listing 2

UNLOAD TABLE_NAME

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

LOAD TABLE_NAME (COLUMN_NAME,...)

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