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>

Updated on: 13-Mar-2020

819 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements