Tips for improving INSERT performance in DB2 Universal Database
From the developerWorks archives
Date archived: January 13, 2017 | First published: March 11, 2004
Improving the performance of database inserts is very important to managing a database, especially in an OLTP environment. This article explains exactly what happens when an insert occurs, looks at alternatives, and examines issues that affect insert performance, such as locking, index maintenance, and constraint management. And, to back up his advice, the author includes performance measurement results.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.