Explain the difference between column storage and row storage?
Answer Posted / Ramendr Tiwari
Column Storage and Row Storage are two storage concepts in SAP HANA. In Column Storage, data is stored vertically (i.e., all columns of a table share the same storage space). This approach helps in optimizing queries that filter on a specific column, as it reduces I/O operations. On the other hand, Row Storage stores data horizontally (i.e., each row occupies its own space). It is useful for tables with small numbers of columns and large volumes of data, as it provides faster read performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category