SAP Hanna Row StorE - What is difference between Column Store & Row Store

Column Store: The entries of a column are stored in contiguous memory locations in which tables are using for Analytic purpose like Dimension, Cubes, because for grouping and column functions.

Row Store:In row-order, table data is stored as a sequence of records. It is actually OLTP purpose and like common RDBS tables for the purpose of OTLP transactions.

Additional Info:
In Traditional Computing you use the Row store

In HANA - In Memory Computing,
95% Column Store.
5% Row Store.

Share this article :

Post a Comment

Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved