<div id="docs-body">
 <div class="index">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="dynindex-jointype">
      </a>
      Join Types Index
     </h2>
    </div>
   </div>
  </div>
  <p>
   <a name="jointype-index-top">
   </a>
   <a class="link" href="dynindex-jointype.html#jointype-index-A" title="A">
    A
   </a>
   |
   <a class="link" href="dynindex-jointype.html#jointype-index-C" title="C">
    C
   </a>
   |
   <a class="link" href="dynindex-jointype.html#jointype-index-E" title="E">
    E
   </a>
   |
   <a class="link" href="dynindex-jointype.html#jointype-index-F" title="F">
    F
   </a>
   |
   <a class="link" href="dynindex-jointype.html#jointype-index-I" title="I">
    I
   </a>
   |
   <a class="link" href="dynindex-jointype.html#jointype-index-R" title="R">
    R
   </a>
   |
   <a class="link" href="dynindex-jointype.html#jointype-index-S" title="S">
    S
   </a>
   |
   <a class="link" href="dynindex-jointype.html#jointype-index-U" title="U">
    U
   </a>
  </p>
  <div class="indexdiv">
   <a name="jointype-index-A">
   </a>
   <h3 class="title">
    A
   </h3>
   <p>
    [
    <a class="link" href="dynindex-jointype.html#jointype-index-top">
     index top
    </a>
    ]
   </p>
   <dl>
    <dt>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <h3 class="title">
    ALL
   </h3>
   <dl>
    <dt>
     <a class="xref" href="table-scan-avoidance.html" title="10.2.1.23 Avoiding Full Table Scans">
      Section 10.2.1.23, “Avoiding Full Table Scans”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="bnl-bka-optimization.html" title="10.2.1.12 Block Nested-Loop and Batched Key Access Joins">
      Section 10.2.1.12, “Block Nested-Loop and Batched Key Access Joins”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="explain-output.html" title="10.8.2 EXPLAIN Output Format">
      Section 10.8.2, “EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <a name="jointype-index-C">
   </a>
   <h3 class="title">
    C
   </h3>
   <p>
    [
    <a class="link" href="dynindex-jointype.html#jointype-index-top">
     index top
    </a>
    ]
   </p>
   <dl>
    <dt>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <h3 class="title">
    const
   </h3>
   <dl>
    <dt>
     <a class="xref" href="explain-output.html" title="10.8.2 EXPLAIN Output Format">
      Section 10.8.2, “EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="explain-extended.html" title="10.8.3 Extended EXPLAIN Output Format">
      Section 10.8.3, “Extended EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="mysql-cluster-options-variables.html#mysql-cluster-system-variables" title="25.4.3.9.2 NDB Cluster System Variables">
      Section 25.4.3.9.2, “NDB Cluster System Variables”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="optimizer-hints.html" title="10.9.3 Optimizer Hints">
      Section 10.9.3, “Optimizer Hints”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="order-by-optimization.html" title="10.2.1.16 ORDER BY Optimization">
      Section 10.2.1.16, “ORDER BY Optimization”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="range-optimization.html" title="10.2.1.2 Range Optimization">
      Section 10.2.1.2, “Range Optimization”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="select.html" title="15.2.13 SELECT Statement">
      Section 15.2.13, “SELECT Statement”
     </a>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <a name="jointype-index-E">
   </a>
   <h3 class="title">
    E
   </h3>
   <p>
    [
    <a class="link" href="dynindex-jointype.html#jointype-index-top">
     index top
    </a>
    ]
   </p>
   <dl>
    <dt>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <h3 class="title">
    eq_ref
   </h3>
   <dl>
    <dt>
     <a class="xref" href="bnl-bka-optimization.html" title="10.2.1.12 Block Nested-Loop and Batched Key Access Joins">
      Section 10.2.1.12, “Block Nested-Loop and Batched Key Access Joins”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="explain-output.html" title="10.8.2 EXPLAIN Output Format">
      Section 10.8.2, “EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="index-condition-pushdown-optimization.html" title="10.2.1.6 Index Condition Pushdown Optimization">
      Section 10.2.1.6, “Index Condition Pushdown Optimization”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="merge-table-advantages.html" title="18.7.1 MERGE Table Advantages and Disadvantages">
      Section 18.7.1, “MERGE Table Advantages and Disadvantages”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="mysql-cluster-options-variables.html#mysql-cluster-system-variables" title="25.4.3.9.2 NDB Cluster System Variables">
      Section 25.4.3.9.2, “NDB Cluster System Variables”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="subquery-optimization-with-exists.html" title="10.2.2.3 Optimizing Subqueries with the EXISTS Strategy">
      Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="performance-schema-events-waits-current-table.html" title="29.12.4.1 The events_waits_current Table">
      Section 29.12.4.1, “The events_waits_current Table”
     </a>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <a name="jointype-index-F">
   </a>
   <h3 class="title">
    F
   </h3>
   <p>
    [
    <a class="link" href="dynindex-jointype.html#jointype-index-top">
     index top
    </a>
    ]
   </p>
   <dl>
    <dt>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <h3 class="title">
    fulltext
   </h3>
   <dl>
    <dt>
     <a class="xref" href="explain-output.html" title="10.8.2 EXPLAIN Output Format">
      Section 10.8.2, “EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <a name="jointype-index-I">
   </a>
   <h3 class="title">
    I
   </h3>
   <p>
    [
    <a class="link" href="dynindex-jointype.html#jointype-index-top">
     index top
    </a>
    ]
   </p>
   <dl>
    <dt>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <h3 class="title">
    index
   </h3>
   <dl>
    <dt>
     <a class="xref" href="bnl-bka-optimization.html" title="10.2.1.12 Block Nested-Loop and Batched Key Access Joins">
      Section 10.2.1.12, “Block Nested-Loop and Batched Key Access Joins”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="explain-output.html" title="10.8.2 EXPLAIN Output Format">
      Section 10.8.2, “EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <h3 class="title">
    index_merge
   </h3>
   <dl>
    <dt>
     <a class="xref" href="explain-output.html" title="10.8.2 EXPLAIN Output Format">
      Section 10.8.2, “EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="index-merge-optimization.html" title="10.2.1.3 Index Merge Optimization">
      Section 10.2.1.3, “Index Merge Optimization”
     </a>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <h3 class="title">
    index_subquery
   </h3>
   <dl>
    <dt>
     <a class="xref" href="explain-output.html" title="10.8.2 EXPLAIN Output Format">
      Section 10.8.2, “EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="subquery-optimization-with-exists.html" title="10.2.2.3 Optimizing Subqueries with the EXISTS Strategy">
      Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
     </a>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <a name="jointype-index-R">
   </a>
   <h3 class="title">
    R
   </h3>
   <p>
    [
    <a class="link" href="dynindex-jointype.html#jointype-index-top">
     index top
    </a>
    ]
   </p>
   <dl>
    <dt>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <h3 class="title">
    range
   </h3>
   <dl>
    <dt>
     <a class="xref" href="bnl-bka-optimization.html" title="10.2.1.12 Block Nested-Loop and Batched Key Access Joins">
      Section 10.2.1.12, “Block Nested-Loop and Batched Key Access Joins”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="explain-output.html" title="10.8.2 EXPLAIN Output Format">
      Section 10.8.2, “EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="group-by-optimization.html" title="10.2.1.17 GROUP BY Optimization">
      Section 10.2.1.17, “GROUP BY Optimization”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="index-condition-pushdown-optimization.html" title="10.2.1.6 Index Condition Pushdown Optimization">
      Section 10.2.1.6, “Index Condition Pushdown Optimization”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="index-merge-optimization.html" title="10.2.1.3 Index Merge Optimization">
      Section 10.2.1.3, “Index Merge Optimization”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="optimizer-hints.html" title="10.9.3 Optimizer Hints">
      Section 10.9.3, “Optimizer Hints”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="range-optimization.html" title="10.2.1.2 Range Optimization">
      Section 10.2.1.2, “Range Optimization”
     </a>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <h3 class="title">
    ref
   </h3>
   <dl>
    <dt>
     <a class="xref" href="bnl-bka-optimization.html" title="10.2.1.12 Block Nested-Loop and Batched Key Access Joins">
      Section 10.2.1.12, “Block Nested-Loop and Batched Key Access Joins”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="explain-output.html" title="10.8.2 EXPLAIN Output Format">
      Section 10.8.2, “EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="explain-extended.html" title="10.8.3 Extended EXPLAIN Output Format">
      Section 10.8.3, “Extended EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="index-condition-pushdown-optimization.html" title="10.2.1.6 Index Condition Pushdown Optimization">
      Section 10.2.1.6, “Index Condition Pushdown Optimization”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="index-statistics.html" title="10.3.8 InnoDB and MyISAM Index Statistics Collection">
      Section 10.3.8, “InnoDB and MyISAM Index Statistics Collection”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="merge-table-advantages.html" title="18.7.1 MERGE Table Advantages and Disadvantages">
      Section 18.7.1, “MERGE Table Advantages and Disadvantages”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="mysql-cluster-options-variables.html#mysql-cluster-system-variables" title="25.4.3.9.2 NDB Cluster System Variables">
      Section 25.4.3.9.2, “NDB Cluster System Variables”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="optimizer-hints.html" title="10.9.3 Optimizer Hints">
      Section 10.9.3, “Optimizer Hints”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="derived-table-optimization.html" title="10.2.2.4 Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization">
      Section 10.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions
with Merging or Materialization”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="subquery-optimization-with-exists.html" title="10.2.2.3 Optimizing Subqueries with the EXISTS Strategy">
      Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
     </a>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <h3 class="title">
    ref_or_null
   </h3>
   <dl>
    <dt>
     <a class="xref" href="explain-output.html" title="10.8.2 EXPLAIN Output Format">
      Section 10.8.2, “EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="index-condition-pushdown-optimization.html" title="10.2.1.6 Index Condition Pushdown Optimization">
      Section 10.2.1.6, “Index Condition Pushdown Optimization”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="is-null-optimization.html" title="10.2.1.15 IS NULL Optimization">
      Section 10.2.1.15, “IS NULL Optimization”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="subquery-optimization-with-exists.html" title="10.2.2.3 Optimizing Subqueries with the EXISTS Strategy">
      Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
     </a>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <a name="jointype-index-S">
   </a>
   <h3 class="title">
    S
   </h3>
   <p>
    [
    <a class="link" href="dynindex-jointype.html#jointype-index-top">
     index top
    </a>
    ]
   </p>
   <dl>
    <dt>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <h3 class="title">
    system
   </h3>
   <dl>
    <dt>
     <a class="xref" href="explain-output.html" title="10.8.2 EXPLAIN Output Format">
      Section 10.8.2, “EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="explain-extended.html" title="10.8.3 Extended EXPLAIN Output Format">
      Section 10.8.3, “Extended EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="range-optimization.html" title="10.2.1.2 Range Optimization">
      Section 10.2.1.2, “Range Optimization”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="select.html" title="15.2.13 SELECT Statement">
      Section 15.2.13, “SELECT Statement”
     </a>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <a name="jointype-index-U">
   </a>
   <h3 class="title">
    U
   </h3>
   <p>
    [
    <a class="link" href="dynindex-jointype.html#jointype-index-top">
     index top
    </a>
    ]
   </p>
   <dl>
    <dt>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
  <div class="indexdiv">
   <h3 class="title">
    unique_subquery
   </h3>
   <dl>
    <dt>
     <a class="xref" href="explain-output.html" title="10.8.2 EXPLAIN Output Format">
      Section 10.8.2, “EXPLAIN Output Format”
     </a>
    </dt>
    <dd>
    </dd>
    <dt>
     <a class="xref" href="subquery-optimization-with-exists.html" title="10.2.2.3 Optimizing Subqueries with the EXISTS Strategy">
      Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
     </a>
    </dt>
    <dd>
    </dd>
   </dl>
  </div>
 </div>
 <br/>
</div>
