<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>JOIN Types Index</title><link rel="stylesheet" href="mysql-html.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.69.1"><link rel="start" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="up" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="prev" href="dynindex-isolevel.html" title="Transaction Isolation Level Index"><link rel="next" href="dynindex-operator.html" title="Operator Index"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center"><code class="literal">JOIN</code> Types Index</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="dynindex-isolevel.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="dynindex-operator.html">Next</a></td></tr></table><hr></div><div class="index"><div class="titlepage"><div><div><h2 class="title"><a name="dynindex-jointype"></a><code class="literal">JOIN</code> Types Index</h2></div></div></div><div class="indexdiv"><h3 class="title"><code class="literal">ALL</code></h3><dl><dt><a href="optimization.html#nested-loop-joins" title="7.2.10. Nested-Loop Join Algorithms">Section 7.2.10, “Nested-Loop Join Algorithms”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">const</code></h3><dl><dt><a href="optimization.html#order-by-optimization" title="7.2.13. ORDER BY Optimization">Section 7.2.13, “<code class="literal">ORDER BY</code> Optimization”</a></dt><dt><a href="sql-syntax.html#select" title="12.2.8. SELECT Syntax">Section 12.2.8, “<code class="literal">SELECT</code> Syntax”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">eq_ref</code></h3><dl><dt><a href="optimization.html#in-subquery-optimization" title="7.2.16. Optimizing IN/=ANY Subqueries">Section 7.2.16, “Optimizing <code class="literal">IN</code>/<code class="literal">=ANY</code> Subqueries”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="storage-engines.html#merge-storage-engine" title="13.8. The MERGE Storage Engine">Section 13.8, “The <code class="literal">MERGE</code> Storage Engine”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">fulltext</code></h3><dl><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">index</code></h3><dl><dt><a href="optimization.html#nested-loop-joins" title="7.2.10. Nested-Loop Join Algorithms">Section 7.2.10, “Nested-Loop Join Algorithms”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">index_merge</code></h3><dl><dt><a href="optimization.html#index-merge-optimization" title="7.2.6. Index Merge Optimization">Section 7.2.6, “Index Merge Optimization”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">index_subquery</code></h3><dl><dt><a href="optimization.html#in-subquery-optimization" title="7.2.16. Optimizing IN/=ANY Subqueries">Section 7.2.16, “Optimizing <code class="literal">IN</code>/<code class="literal">=ANY</code> Subqueries”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="sql-syntax.html#optimizing-subqueries" title="12.2.9.10. Optimizing Subqueries">Section 12.2.9.10, “Optimizing Subqueries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">range</code></h3><dl><dt><a href="optimization.html#index-merge-optimization" title="7.2.6. Index Merge Optimization">Section 7.2.6, “Index Merge Optimization”</a></dt><dt><a href="optimization.html#loose-index-scan" title="7.2.14.1. Loose Index Scan">Section 7.2.14.1, “Loose Index Scan”</a></dt><dt><a href="optimization.html#nested-loop-joins" title="7.2.10. Nested-Loop Join Algorithms">Section 7.2.10, “Nested-Loop Join Algorithms”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="optimization.html#range-optimization" title="7.2.5. Range Optimization">Section 7.2.5, “Range Optimization”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ref</code></h3><dl><dt><a href="optimization.html#myisam-index-statistics" title="7.4.6. MyISAM Index Statistics Collection">Section 7.4.6, “<code class="literal">MyISAM</code> Index Statistics Collection”</a></dt><dt><a href="optimization.html#in-subquery-optimization" title="7.2.16. Optimizing IN/=ANY Subqueries">Section 7.2.16, “Optimizing <code class="literal">IN</code>/<code class="literal">=ANY</code> Subqueries”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="storage-engines.html#merge-storage-engine" title="13.8. The MERGE Storage Engine">Section 13.8, “The <code class="literal">MERGE</code> Storage Engine”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ref_or_null</code></h3><dl><dt><a href="optimization.html#is-null-optimization" title="7.2.8. IS NULL Optimization">Section 7.2.8, “<code class="literal">IS NULL</code> Optimization”</a></dt><dt><a href="optimization.html#in-subquery-optimization" title="7.2.16. Optimizing IN/=ANY Subqueries">Section 7.2.16, “Optimizing <code class="literal">IN</code>/<code class="literal">=ANY</code> Subqueries”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">system</code></h3><dl><dt><a href="sql-syntax.html#select" title="12.2.8. SELECT Syntax">Section 12.2.8, “<code class="literal">SELECT</code> Syntax”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-logs-cluster-log" title="17.5.5.1. MySQL Cluster — Messages in the Cluster Log">Section 17.5.5.1, “MySQL Cluster — Messages in the Cluster Log”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">unique_subquery</code></h3><dl><dt><a href="optimization.html#in-subquery-optimization" title="7.2.16. Optimizing IN/=ANY Subqueries">Section 7.2.16, “Optimizing <code class="literal">IN</code>/<code class="literal">=ANY</code> Subqueries”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="sql-syntax.html#optimizing-subqueries" title="12.2.9.10. Optimizing Subqueries">Section 12.2.9.10, “Optimizing Subqueries”</a></dt></dl></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="dynindex-isolevel.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="dynindex-operator.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Transaction Isolation Level Index </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> Operator Index</td></tr></table></div></body></html>
