cancel
Showing results for 
Search instead for 
Did you mean: 

Improving performance during insert

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182302
Active Contributor
0 Kudos

Hi Srivatsan,

Were the tables partitioned?

Regards,

Krishna Tangudu

Former Member
0 Kudos

No Krishna .. tables are unpartitioned.

What is the best practice to be followed when partitioning the tables? I haven't tried that yet. I searched for the topic and found in "SAP BW COOKBOOK" about the ROUNDROBIN PARTITION . Is this what you are referring to ?