Skip to Content
Former Member
Oct 23, 2012 at 03:01 PM

Is really all data in memory?


After doing some tests ( final results will be made available at this other discussion ) i was wondering what is going on.

I found this on wikipedia:

The row store is optimized for concurrent WRITE and READ operations. It keeps all index structures in-memory rather than persisting them on disk. It uses a technology that is optimized for concurrency and scalability in multi-core systems. Typically, Metadata or rarely accessed data is stored in a row-oriented format.( )

And from HANA's reference we can read:


 LOAD <table_name> {DELTA | ALL | (<column_name>, ...)} 


The LOAD statement loads the column store table data to memory explicitely instead of on first access.

( )

The LOAD statement is explicitly for column store, if you try to run it for a row store table it give's you an error.

I serched a little bit on HANA's sites and couldn't find an explicit statement so can anyone confirm:

SAP HANA works with full data in memory only for column store, when working with row store only indexing structures are held in memory. Is that so?