<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="data-change-optimization">
      </a>
      10.2.5 Optimizing Data Change Statements
     </h3>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="insert-optimization.html">
       10.2.5.1 Optimizing INSERT Statements
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="update-optimization.html">
       10.2.5.2 Optimizing UPDATE Statements
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="delete-optimization.html">
       10.2.5.3 Optimizing DELETE Statements
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045227673616">
  </a>
  <p>
   This section explains how to speed up data change statements:
   <a class="link" href="insert.html" title="15.2.7 INSERT Statement">
    <code class="literal">
     INSERT
    </code>
   </a>
   ,
   <a class="link" href="update.html" title="15.2.17 UPDATE Statement">
    <code class="literal">
     UPDATE
    </code>
   </a>
   , and
   <a class="link" href="delete.html" title="15.2.2 DELETE Statement">
    <code class="literal">
     DELETE
    </code>
   </a>
   . Traditional OLTP
        applications and modern web applications typically do many small
        data change operations, where concurrency is vital. Data
        analysis and reporting applications typically run data change
        operations that affect many rows at once, where the main
        considerations is the I/O to write large amounts of data and
        keep indexes up-to-date. For inserting and updating large
        volumes of data (known in the industry as ETL, for
   <span class="quote">
    “
    <span class="quote">
     extract-transform-load
    </span>
    ”
   </span>
   ), sometimes you use other
        SQL statements or external commands, that mimic the effects of
   <a class="link" href="insert.html" title="15.2.7 INSERT Statement">
    <code class="literal">
     INSERT
    </code>
   </a>
   ,
   <a class="link" href="update.html" title="15.2.17 UPDATE Statement">
    <code class="literal">
     UPDATE
    </code>
   </a>
   , and
   <a class="link" href="delete.html" title="15.2.2 DELETE Statement">
    <code class="literal">
     DELETE
    </code>
   </a>
   statements.
  </p>
 </div>
 <br/>
</div>
