JOIN Types Index

ALL

Section 7.2.15.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 7.2.11, “Nested-Loop Join Algorithms”

const

Section 7.2.17, “ORDER BY Optimization”
Section 12.2.9, “SELECT Syntax”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”

eq_ref

Section 7.2.15.3, “Batched Key Access Joins”
Section 7.2.8, “Index Condition Pushdown Optimization”
Section 7.2.20, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 13.10, “The MERGE Storage Engine”

fulltext

Section 7.2.1, “Optimizing Queries with EXPLAIN

index

Section 7.2.15.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 7.2.11, “Nested-Loop Join Algorithms”
Section 7.2.1, “Optimizing Queries with EXPLAIN

index_merge

Section 7.2.6, “Index Merge Optimization”
Section 7.2.1, “Optimizing Queries with EXPLAIN

index_subquery

Section 7.2.20, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 12.2.10.10, “Optimizing Subqueries”

range

Section 7.2.15.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 7.2.8, “Index Condition Pushdown Optimization”
Section 7.2.6, “Index Merge Optimization”
Section 7.2.18.1, “Loose index scan”
Section 7.2.11, “Nested-Loop Join Algorithms”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 7.2.5, “Range Optimization”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”

ref

Section 7.4.6, “MyISAM Index Statistics Collection”
Section 7.2.15.3, “Batched Key Access Joins”
Section 7.2.8, “Index Condition Pushdown Optimization”
Section 7.2.20, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 13.10, “The MERGE Storage Engine”

ref_or_null

Section 7.2.9, “IS NULL Optimization”
Section 7.2.8, “Index Condition Pushdown Optimization”
Section 7.2.20, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN

system

Section 12.2.9, “SELECT Syntax”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”

unique_subquery

Section 7.2.20, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 12.2.10.10, “Optimizing Subqueries”