Skip to Content
0
Nov 23, 2017 at 05:14 AM

Hana Table Partition field selection

181 Views Last edit Nov 23, 2017 at 05:15 AM 2 rev

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 ?