Advantages of using Column based tables in SAP HANA

In a Column store table, Data is stored vertically. So, similar data types come together as shown in the example above. It provides faster memory read and writes operations with help of In-Memory Computing Engine.

In a conventional database, data is stored in Row based structure i.e. horizontally. SAP HANA stores data in both row and Column based structure. This provides Performance optimization, flexibility and data compression in HANA database.

Storing Data in Columnar based table has following benefits −

  • Data Compression
  • Faster read and write access to tables as compared to conventional Row based storage
  • Flexibility & parallel processing
  • Perform Aggregations and Calculations at higher speed

For more details you can refer our HANA tutorial link: