on 04-23-2023 4:30 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.