Hana Table Partition field selection

[bhargav_bhatt]

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 ?

[jgleichmann]

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.