topic Re: HANA partition table in DevOps and System Administration Forum

HANA partition table

philip0929 — Thu, 15 Jul 2021 17:25:45 GMT

Hi guys,

I would like to ask because we have a scale-up database and there are DB alerts that a table is growing significantly.

The recommendation is to partition the table. The question is, is there an improvement to partition a table in a scale-up DB?

Is there any recommendation that you can give regarding this alert?

SAPABAP1.CDPOS has grown significantly.

SAPABAP1.DBERDLB has grown significantly.

SAPABAP1.DBERCHZ3 has grown significantly.

SAPABAP1.DFKKOPK has grown significantly.

Re: HANA partition table

S_Sriram — Thu, 15 Jul 2021 18:49:18 GMT

Hi Philip

Have you gone thru the blog which tells about the HANA table partitioning

https://blogs.sap.com/2020/02/09/hana-partitioning-2-billion-rows-limitation-part-ii-bsoh-s-4hana/

Regards

Re: HANA partition table

former_member644293 — Fri, 16 Jul 2021 15:50:58 GMT

Philip,

Yes. there will be improvement considering 2B limit on and distribution load across many nodes being OLAP system makes administartion easier.

as your system is scale-out it makes sense to partition depending on the access type, data, type of query etc., Consult BW team who will be guidance on the right type of partition.

Cardinality
HASH Partitioning
Range Partitioning
Multi-level partitioning

1,3 are common in BW, however they may choose different option depending the business scenario.

Hope this helps.

Regards,

Re: HANA partition table

philip0929 — Fri, 16 Jul 2021 16:02:46 GMT

we are scale-up NOT scale-out