<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="statement-optimization">
      </a>
      10.2 Optimizing SQL Statements
     </h2>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="select-optimization.html">
       10.2.1 Optimizing SELECT Statements
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="subquery-optimization.html">
       10.2.2 Optimizing Subqueries, Derived Tables, View References, and Common Table
Expressions
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="information-schema-optimization.html">
       10.2.3 Optimizing INFORMATION_SCHEMA Queries
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="performance-schema-optimization.html">
       10.2.4 Optimizing Performance Schema Queries
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="data-change-optimization.html">
       10.2.5 Optimizing Data Change Statements
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="permission-optimization.html">
       10.2.6 Optimizing Database Privileges
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="miscellaneous-optimization-tips.html">
       10.2.7 Other Optimization Tips
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045230371248">
  </a>
  <p>
   The core logic of a database application is performed through SQL
      statements, whether issued directly through an interpreter or
      submitted behind the scenes through an API. The tuning guidelines
      in this section help to speed up all kinds of MySQL applications.
      The guidelines cover SQL operations that read and write data, the
      behind-the-scenes overhead for SQL operations in general, and
      operations used in specific scenarios such as database monitoring.
  </p>
 </div>
 <br/>
</div>
