Join Types Index
Prev
Next
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.8.2, “EXPLAIN Output Format”
Section 8.2.1.21, “How to Avoid Full Table Scans”
Section 8.2.1.10, “Nested-Loop Join Algorithms”
C
[
index top
]
const
Section 8.8.3, “EXPLAIN EXTENDED Output Format”
Section 8.8.2, “EXPLAIN Output Format”
Section 18.3.3.8.2, “MySQL Cluster System Variables”
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.2.1.14.3, “Batched Key Access Joins”
Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.6, “Index Condition Pushdown Optimization”
Section 15.7.1, “MERGE Table Advantages and Disadvantages”
Section 18.3.3.8.2, “MySQL Cluster System Variables”
Section 8.2.1.18.4, “Optimizing Subqueries with EXISTS Strategy”
Section 22.9.4.1, “The events_waits_current Table”
F
[
index top
]
fulltext
Section 8.8.2, “EXPLAIN Output Format”
I
[
index top
]
index
Section 8.2.1.14.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 8.8.2, “EXPLAIN Output Format”
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.2.1.14.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 8.8.2, “EXPLAIN Output Format”
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.2.1.14.3, “Batched Key Access Joins”
Section 8.8.3, “EXPLAIN EXTENDED Output Format”
Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.6, “Index Condition Pushdown Optimization”
Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”
Section 15.7.1, “MERGE Table Advantages and Disadvantages”
Section 18.3.3.8.2, “MySQL Cluster System Variables”
Section 8.2.1.18.3, “Optimizing Derived Tables and View References”
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.6, “Index Condition Pushdown Optimization”
Section 8.2.1.8, “IS NULL Optimization”
Section 8.2.1.18.4, “Optimizing Subqueries with EXISTS Strategy”
S
[
index top
]
system
Section 8.8.3, “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”