HANA - Table Partition number

[former_member201054]

Hi Experts,

* How to decide the number of partitions to a column store table whose size exceeded 2 Billon records. any random number will work?

* Can it differ partition method-wise ( HASH, Round Robin, and Range)

2044468 – FAQ: SAP HANA Partitioning ( already referred)

Please answer.

Thanks in advance

[simon25]

Hi Daniel,

KBA 2044468 - FAQ: SAP HANA Partitioning already covers these two questions really.

But generally, If you partition tables due to the 2 billion limit it is usually acceptable if individual partitions contain up to 1.5 billion records.

Each Individual partition is recommended to be kept around the 50GB~ in size too. A mini check report will flag this as an alert for example.

"M0525 - Tables / partitions with large memory size"

So the number of partitions should be based on these two thresholds. 4 partitions is usually a good starting point for non-partitioned tables reaching the 2 billion threshold mark, but we would always recommend testing this in a non-prod environment first.

HASH partitioning is the recommended partition specification where no recommended method exists for a particular table. RANGE is usually used by customers where the table is to be partitioned on time based columns such as a year for example.

But please check section '27. Are there specific partitioning recommendations for certain SAP applications and tables?' -> KBA 2044468 , for the table you are partitioning and if there is a particular recommended partitioning column and method like HASH, RANGE etc. for the SAP standard tables listed there.

Kind Regards

Simon