on 08-04-2014 6:20 AM
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
Hi Srivatsan,
Were the tables partitioned?
Regards,
Krishna Tangudu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.