Tips for improving INSERT performance in DB2 Universal Database

From the developerWorks archives

Bill Wilkins

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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=86637
ArticleTitle=Tips for improving INSERT performance in DB2 Universal Database
publish-date=03112004