cancel
Showing results for 
Search instead for 
Did you mean: 

Row Store Vs Column Store

Former Member
0 Kudos

Hi All,

           I am  new to SAP HANA, I have some doubts like,

1) What is Column Store and Row Store and how they work?

2) When to use column store and row store?

3) which one is better for data loading?

4) Which one is better for reporting?

which supports the indexes?

If any one have information regarding above queries Please share me.

Thanks,

Ramana

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

One characteristic that makes SAP HANA unique is that it can offer a platform to house both column and row store tables..!

Because SAP HANA is optimized or tuned for storing data in columns over data in rows, you should use column store tables whenever possible. Reading data is much faster in column-based tables; from a data storage perspective, columnar storage and compression are two of SAP HANA’s best offerings. In a column store table, data simply compresses at higher rates.

Row store tables are exactly as they sound. Data is stored in memory but in a row fashion. With row store tables is that there is virtually no additional compression available by using a row store table

Column store tables clearly offer many benefits from data compression to tuning options to pure speed that is otherwise unobtainable with conventional row storage.

In Short - Use ROW STORE for OLTP ( more Writes) and use COLUMN store for OLAP ( More READS).

Hope this helps

Cheers

Ram K

Answers (2)

Answers (2)

vivekbhoj
Active Contributor
0 Kudos

Hi Ramana,

Check this document to learn more about row store and column store:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70d16119-ad21-2e10-de8b-eaaedf86b...

It will be better if you learn more about InMemory through OpenHPI course so that you could answer these questions yourself:

https://openhpi.de/course/imdb2013

Regards,

Vivek

Former Member
0 Kudos

Please search before posting, you will get enough links to answer all your queries

chech the links below

1) What is Column Store and Row Store and how they work?   Search > Just too much info available for it

2) When to use column store and row store?  in HANA for analytic usage virtually always

3) which one is better for data loading?  Minimal difference although theoretically row store is little better suited

4) Which one is better for reporting? Column store

which supports the indexes? both but does not make any perceivable difference in performance in normal use case