When to use ROW STORE ? WHEN TO USE COLUMN STORE ?

The SAP HANA database supports both row-based and column-based storage. However, it is optimized for column storage. Tables that are organized in columns are read optimized and have better compression rates than tables organized in rows. Furthermore, some features of the SAP HANA database, such as partitioning, are available only for column tables. Column-based storage is typically suitable for big tables with bulk updates. However, update and insert performance is better on row tables. Row-based storage is typically suitable for small tables with frequent single updates.

The following table outlines the criteria that you can use to decide whether to store your data tables as column tables or row tables:

When to use ROW STORE ? WHEN TO USE COLUMN STORE ?



tags: hana row store, Row-based or Column-based? - SAP HANA Tutorial, Creating SAP HANA Column-Store Tables, What is Row and column store? specifically in SAP HANA , HANA, Columns, and OLTP - SAP HANA, Understanding Row Store & Column Store? ,
Share this article :

Post a Comment

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