We have a big table that we are loading to Hana every month during system refresh. It is taking lot of time to load as the table is very big and its not partitioned. Wanted to know few basic things before I start working on the Table Partitioning.
1. How do we check which Partition Specification is suitable for my Table ( Hash, Round Robin or Range ). Do I need to check with Developer as which option is correct.
2. Do I need to create the table in HANA before I do the replication with Partitions. If yes, can I copy the same table structure from our ECC system and create the table.
3. If I use Hash, I need to specify columns as partitioning columns. How do we find which columns we need to specify.
I have already gone through the SAP documents and your personnel responses would be appreciated.