transfer to main memory

[Former Member]

hi i have transfered 10 million records to a table in my schema.

how can i transfer it to main memory?

can u plz provide the Doc path if any...

regards

Siva

[former_member184768]

Hi Siva,

Please check M_CS_TABLES entry for your table (table_name = <your_table_name>) and check the columns memory_size_in_main and memory_size_in_delta (also check the no of rows in both main and delta).

Since you have high data load, the delta merge should have been triggered (depending on your system setting) and your data should already be in the main memory.

If not, you can initiate the delta merge or load table in the main memory.

Regards,

Ravi

[patrickbachmann]

If you right click on the table and choose LOAD it will be loaded into memory. 

[patrickbachmann]

See page 58 - Load, Unload and Merge table data

http://help.sap.com/hana/hana1_imdb_studio_admin_en.pdf