I have a procedure in HANA that has 6 inserts to 6 different tables. The procedure inserts around 3Lakh+ records. It takes minimum of 10 seconds to execute.
Is there any way to improve the speed of insert (in SQLscript).
The tables that I insert records are column based tables which I know would reduce the performance of insert, but still it would be useful to know any suggestions from you all.