...
From our performance tests for SAP Hana SQL storage specifically, the use of column columnar based table compared to row based tables show significant strong advantages in performance and disk space footprint.
There were unexpected issues during our tests when the memory capacity of the machine where SAP Hana was installed was too small. We experienced minimal issues when installing SAP Hana database with at least 64G 64GB memory capacity.
Cache Size and Segmentation
...