O'Reilly logo

Oracle by Guy Harrison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required