Chapter 14. DML Tuning
In this chapter, we look at issues relating to the performance of Data Manipulation Language (DML) statements. These statements (INSERT, UPDATE, MERGE, and DELETE) alter the information contained within your Oracle database.
Even in transaction processing environments, most database activity is related to data retrieval. You need to find data to change or delete it, and even inserts often have a query component. However, there are many DML-specific optimizations available, and we cover these in this chapter.
One of the key features of relational databases is the ability to group multiple DML statements into a group of statements that must succeed or fail as a unit. These groups of statements are known as transactions. ...