Load and Unload a Table in SAP HANA Using SQL Query

In SAP HANA, it is possible to manually load and unload individual tables and table columns.

• You can perform loading of table to precisely measure the total or “worst case” amount of memory used by a particular table.
• A table is unload from database to actively free up memory.

You can use following SQL queries to perform load/unload of table −

LOAD <table_name>
UNLOAD <table_name>