Skip to Content
avatar image
Former Member

Hana Table Partition field selection

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 26, 2018 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.

    Add comment
    10|10000 characters needed characters exceeded