Skip to Content

Hana Table Partition field selection

Nov 23, 2017 at 05:14 AM


avatar image
Former Member

Dear Experts,

We have our ECC PRD system on HANA DB single node.

We are having alert in hana studio regarding table partition for more than 2 billion record.

Now my question is while doing hash table partition which primary field need to be selected ?

Should partition to be done on all the primary field ?

Should it be done on selective fields ? would it affect DB performance ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jens Gleichmann Jan 26 at 07:36 AM

Check note 1899817 (Business Suite on SAP HANA database: table placement). Apply all needed parameters and the attached file TABLE_PLACEMENT_ERP_ SP10+.TXT (replace the placeholders). Afterwards you can execute a reorg/redistribution which will automatically split you affected tables which the correct attributes.

Further details:

1958216 - HANA landscape redistribution configuration

Check this blog for details.

10 |10000 characters needed characters left characters exceeded