|
From a pure SQL standpoint, an INSERT statement must:
- Acquire an empty block to store the data (from the table's freelist).
- Insert and commit the data block.
There are two areas where you can improve Oracle SQL INSERT performance:
- Parallelize the inserts (if you have an SMP server).
- Use the APPEND hint to ensure that you get an empty data block by raising the high-water mark for the table.
Here is a good article on improving INSERT performance.
|