Write SQL Script result to a table

[Former Member]

Hi, i have an SQL Script Procedure that produce 2 different tables in output .

I want to write this result to 2 phisical tables in bulk insert .

how can i do it ?

thank you

[Former Member]

inserts in HANA is very slow , due to delta merge , you can write a Stored Proc which normally called by BODS. Few points on the SP is that , you should turn auto merge off , and have the tables partitioned if the data volume is huge .

There are many optimization techniques for large data inserts in HANA

[rindia]

Hi Carlo,

One solution could be to write another procedure to insert/update the table you want or else within the same procedure can do.

Regards

Raj