SAP HANA Best practices table partitioning

SAP HANA Best practices table partitioning


  • Keep the number of partitioned tables low.
  • Keep the number of partition per table low.
  • Keep the number of key columns low.
  • For SAP Business Suite on HANA, keep the partitions on same host.
  • Repartitioning aaa multiple or a division of current number of partitions.
  • No extra unique constrains.


No comments:

Post a Comment