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

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

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?

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?

What SQL statement performs a hard merge in SAP HANA, and how does it behave with respect to the decision and token mechanisms?