Skip to Content
0
Jun 01, 2020 at 08:36 PM

Alternative for updating DB table using an internal table from AMDP

216 Views

Hi,

I am trying to find an alternative for updating the HANA DB table using an internal table without having to use AMDP.

Currently, we use an AMDP as shown below. The problem using it this way is we have to pass packets of 500,000 records each time to update millions of records. We can see this causes huge memory consumption when we check expensive statements in DBACOCKPIT.

Any other alternative which can consume less memory and perform better in terms of performance?

Regards,

VJ

Attachments