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. ...

Get Oracle now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.