SAP HANA 2.0 Administration · Table Internals: Stores, Compression, Partitioning & MVCC

Why does SAP HANA still need indexes despite being an in-memory database?

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

Get the answer in the app

More in Table Internals: Stores, Compression, Partitioning & MVCC

What is a memory merge in SAP HANA, and what risk does it carry?

What SQL statement performs a forced merge in SAP HANA, and what makes it different from a hard merge?

In which cases does SAP recommend a CPBTREE index over a BTREE index for a row-store table?

What are merge tokens in SAP HANA, and what is the default number of tokens per table?

How do you add a partition to an existing partitioned SAP HANA table, and which partition types do NOT allow adding partitions?

When can hash partitioning use partition pruning in SAP HANA, and when can't it?