Is SAP HANA a column or row-oriented database?

Usually, relational databases use data storage based on rows. SAP HANA supports both row and column-based storage. SAP HANA stores data primarily in columnar format for processing. However, unlike other columnar databases, HANA's columnar store is used effectively for all database operations, such as read and write. In SAP, most of the tables in the database are columnar oriented tables which include both transactional and master data tables. 

Was this answer helpful?


Top Questions & Answers

Related FAQs

  • How SAP HANA is different from other databases?
    SAP HANA is different from other traditional databases in terms of architecture, how data is stored and accessed. It's also different in terms of&...
  • What is SAP HANA Cockpit?
    SAP HANA cockpit is a web-based HTML5 user interface that you access through a browser. It runs on SAP HANA extended application services, advanc...