SAP S/4HANA Administration · SAP HANA Architecture & Persistence

Why is row-based storage good for OLTP but bad for OLAP, and how does column storage flip this?

The full answer is available in the KnowCard app, with spaced-repetition review and AI explanations.

Get the answer in the app

More in SAP HANA Architecture & Persistence

Column-store writes are costly — how does SAP HANA mitigate that?

When reading a column table, where does HANA look besides the main column store?

What role do indexes still play in SAP HANA column tables?

What's the difference between the SAP HANA nameserver and indexserver?

What's the SAP HANA service port schema for instance number xx?

Where are SAP HANA database parameters stored, compared with the instance profile directory?