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>