suresh What is the difference between row store and column store in SAP HANA?
In SAP HANA, the row store and column store are two different types of storage mechanisms used to store data.
Row Store:
The row store in SAP HANA stores data row by row. This means that all the columns of a row are stored together. Row store is ideal for OLTP (Online Transaction Processing) scenarios where individual rows are frequently read or updated.
Column Store:
In contrast, the column store in SAP HANA stores data column by column. This means that all values of a particular column are stored together. Column store is ideal for OLAP (Online Analytical Processing) scenarios where aggregate calculations and analytical queries are performed on a large set of data.
Overall, the key difference between row store and column store in SAP HANA lies in how the data is physically stored and accessed, with each storage type optimized for different types of data processing workloads.
Please login or Register to submit your answer