Load and unload a table in SAP HANA using SQL query

Why do we perform loading and unloading of tables in SAP HANA database? What is the SQL query to perform this function?

0 0

1 Answer

SAP Developer

Answered on 25th Apr, 2018

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>

0 0