Which rules should you consider when creating a table distribution plan for SAP Business Suite powered by SAP HANA to get the best possible results? (Choose two.)
Which rules should you consider when creating a table distribution plan for SAP Business Suite powered by SAP HANA to get the best possible results? (Choose two.)
When creating a table distribution plan for SAP Business Suite powered by SAP HANA, it is essential to keep the number of key columns low. This approach increases the efficiency of query processing by reducing the complexity of index maintenance and join operations. Additionally, keeping the number of partitioned tables low helps to avoid excessive maintenance and management overhead that comes with a high number of partitions and tables. By adopting these practices, you ensure better performance and manageability of the database system.
HA201-SAP HANA 2.0 SPS06 - High Availability and Disaster Tolerance Administration. Best Practices for Table Partitioning To create an optimal partitioning plan, you should try to follow the table partitioning best practices: ●Keep the number of partitioned tables low ●Keep the number of partitions per table low ●Keep the number of key columns low ●For SAP Business Suite on HANA, keep all partitions on same host ●Repartitioning rules ●Avoid unique constraints