...
From our performance tests for SAP Hana SQL storage specifically, the use of column based table compared to row based tables show significant 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 our SAP Hana in a machine with a 32G database with at least 64G memory capacity.
Cache Size and Segmentation
...