What are row and column storage in SAP HANA?
SAP Online Classes provides Best SAP training Online based on current industry standards that helps attendees to secure placements in their dream jobs at MNCs. SOC is one of the most credible ERP SAP Online training provider, offering hands on practical knowledge and full job assistance with basic as well as advanced level ERP SAP Implementation Training. At SOC ERP SAP training Online is conducted by subject specialist corporate professionals with 14+ years of experience in managing real-time ERP SAP projects.
What are row and column storage in SAP HANA?
Answer
Full Stack Software Developer
-
Data in the SAP HANA database stores in two ways; row storage, and column storage.
Row storage is the method of storing data in a horizontal fashion. It is similar to how data is stored traditionally in disk databases. However, there is one main difference between the SAP HANA row storage and traditional row storage.
That is, in SAP HANA, data is stored in rows in the main memory and in traditional databases, data is stored in rows in the disk storage.
Column storage method stores data in a columnar fashion (linear/ vertical). Data is compressed efficiently in column stores. It improves SAP HANA’s performance by optimizing both the read and write operations on data.
Data is stored in the column storage area which is divided into two sections; Main storage and Delta Storage.
