Re: how to improve the performance of Oracle Insert operation?# Database - 数据库
q*e
1 楼
According to my experience in DB2 and Informix, batch insert
commit(usually about thousands of record) is faster than
single record or less than one hundred record commit. I
think in Oracle it should work too. Also, in oracle, there
should have some parameters to be adjusted for performance.
You can ask some oracle experts.
commit(usually about thousands of record) is faster than
single record or less than one hundred record commit. I
think in Oracle it should work too. Also, in oracle, there
should have some parameters to be adjusted for performance.
You can ask some oracle experts.