Unloading the rarely used column tables on to the persistent layer ?

[Former Member]

Hello Folks,

Can someone please let me know how to unload the column tables of a particular schema that are not being used every now and then, on to the persistent layer?

eg: UNLOAD "SCHEMA_NAME"."TABLE_NAME" will unload only a particular table on to the disk, but how do i select the tables that were inactive say since the last 1 week of a particular schema.

Thanks in advance.

Regards,

Krishna

[AtulKumarJain · Accepted solution]

Hi Krishana,

Please check

How to selectively unload/load data from RAM | SAP HANA

BR

Atul

[Former Member · Accepted solution]

Hi Atul,

Thank you for providing me with the information,As per the link you sent me i am assuming that the process of unloading the rarely used inactive tables on to the DISK is totally managed by the HANA's inbuilt algorithm. But HANA only unloads the tables on to the persistent layer when the memory reaches to or above 90% of the memory, There should be a way out .

BTW its krishna and not  Krishana

Regards,

Krishna

[lbreddemann · Accepted solution]

What is the advantage you see in manually unloading tables/columns when there still is memory available?

What do you get out of this additional (and actually high effort) action?