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

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

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?

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