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.
Dig Deeper on Oracle and SQL
Related Q&A from Don Burleson
Suppose you have a table which has only two columns, namely locid (not primary) and place. In Oracle, which query should I run to get the output as ... Continue Reading
I have a query that retrieves around 10 records. I have a task to concatenate the values separated with ','. I would like to know if Oracle has any ... Continue Reading
I have a barcode application running on a Sun platform with Oracle9i. Oracle is 92% full. I have space in other locations. Is there any way to ... Continue Reading