Skip to Content
0
Former Member
Aug 04, 2014 at 05:20 AM

Improving performance during insert

25 Views

Hi,

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.

Thanks

S.Srivatsan