How to remove DOKTL,DOK* table from memory by default

[mandeep_kauldhar]

Hello guys, how can i remove DOKTL, DOK* table from memory by default on start of HANA DB? i tried to change table/view TABLES/m_cs_tables no success. I am talking with respect to SAP EHP7 based upon SAP hana db 1.0 sp11.

I want to reduce memory usage by default as we are not going to use document related tables. So trying to see if we diable few table to load into memory at start of DB; once it is accessed in operation i don't mind having them in memory.

I know the consequence for performance if it is not in memory.

I tried to unload it from memory using DB studio but didn't worked on this table but other tables i tried it worked.

Mani

[Former Member · Accepted solution]

See SAP Note 2127458 for information about configuring the load and unload behavior of SAP HANA. If unloading of these tables don't work for you, further details like executed command and error message are required.

[mandeep_kauldhar · Accepted solution]

That does helped to resolve issue but again if i use any T-code which might use document it will buffer it up.

For others i used command

ALTER TABLE "DOKTL" PRELOAD NONE