Join Types Index

A | C | E | F | I | R | S | U

A

[index top]

ALL

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

C

[index top]

const

Section 8.8.4, “EXPLAIN EXTENDED Output Format”
Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.15, “ORDER BY Optimization”
Section 13.2.9, “SELECT Syntax”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”

E

[index top]

eq_ref

Section 8.8.2, “EXPLAIN Output Format”
Section 15.7.1, “MERGE Table Advantages and Disadvantages”
Section 8.2.1.14.3, “Batched Key Access Joins”
Section 8.2.1.6, “Index Condition Pushdown Optimization”
Section 8.2.1.18.4, “Optimizing Subqueries with EXISTS Strategy”

F

[index top]

fulltext

Section 8.8.2, “EXPLAIN Output Format”

I

[index top]

index

Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.14.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 8.2.1.10, “Nested-Loop Join Algorithms”

index_merge

Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.4, “Index Merge Optimization”

index_subquery

Section 8.8.2, “EXPLAIN Output Format”
Section 13.2.10.10, “Optimizing Subqueries”
Section 8.2.1.18.4, “Optimizing Subqueries with EXISTS Strategy”

R

[index top]

range

Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.14.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 8.2.1.6, “Index Condition Pushdown Optimization”
Section 8.2.1.4, “Index Merge Optimization”
Section 8.2.1.16.1, “Loose Index Scan”
Section 8.2.1.10, “Nested-Loop Join Algorithms”
Section 8.2.1.3, “Range Optimization”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”

ref

Section 8.8.4, “EXPLAIN EXTENDED Output Format”
Section 8.8.2, “EXPLAIN Output Format”
Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”
Section 15.7.1, “MERGE Table Advantages and Disadvantages”
Section 8.2.1.14.3, “Batched Key Access Joins”
Section 8.2.1.6, “Index Condition Pushdown Optimization”
Section 8.2.1.18.3, “Optimizing Subqueries in the FROM Clause (Derived Tables)”
Section 8.2.1.18.4, “Optimizing Subqueries with EXISTS Strategy”

ref_or_null

Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.8, “IS NULL Optimization”
Section 8.2.1.6, “Index Condition Pushdown Optimization”
Section 8.2.1.18.4, “Optimizing Subqueries with EXISTS Strategy”

S

[index top]

system

Section 8.8.4, “EXPLAIN EXTENDED Output Format”
Section 8.8.2, “EXPLAIN Output Format”
Section 13.2.9, “SELECT Syntax”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”

U

[index top]

unique_subquery

Section 8.8.2, “EXPLAIN Output Format”
Section 13.2.10.10, “Optimizing Subqueries”
Section 8.2.1.18.4, “Optimizing Subqueries with EXISTS Strategy”