Main concepts of SAP HANA Database

The three main concepts of the SAP HANA database are as follows:

1. Column Store and Row Store

2. Compression of the Column Store

3. Insert only on Delta & Delta Merge of the Column Store

Column and Row Store:

Row Vs Column Store:

If you want to report on line items only, that is, on all the columns of a single record of a table, then the row store is more suitable. This is because reconstructing the complete row is one of the most expensive operations for a column-based table. Typical examples are customizing tables or l