2044468 - FAQ: SAP HANA Partitioning

You have a question related to SAP HANA partitioning.

SAP HANA

Record count,Table growth,Billion,HASH,ROUNDROBIN,RANGE,CHECK_PARTITIONING,CHECK_PARTITIONING_DATA,too many records If you want to change the column for HASH partitioning, the resource usage is limited because the source partitions are processed sequentially. You can achieve a higher resource utilization and an overall runtime reduction with the following two-step approach:
ALTER TABLE <table> PARTITION BY HASH (<prev_column>) PARTITIONS <count>, HASH (<new_column>) PARTITIONS <count>;ALTER TABLE <table> PARTITION BY HASH (<new_column>) PARTITIONS <count>; , KBA , HAN-DB-ENG , SAP HANA DB Engines , HAN-DB , SAP HANA Database , How To