We want to copy 16 billion records from one table to another table in HANA DB. At the moment it takes 6 hours to copy 2 billion records. At this rate we might need couple of days to complete this activity. Is there a faster way to achieve the same?
Our table are range partitioned and we are using following code:
INSERT INTO "SAPABAP1"."TABLE1" ( SELECT * FROM "SAPABAP1"."TABLE1_BCKUP" );
we are on HANA 2.0 and DB version 30 and SP03.