Join Types Index
Prev
Next
Join Types Index
A
|
C
|
E
|
F
|
I
|
R
|
S
|
U
A
[
index top
]
ALL
Section 8.2.1.16, “Avoiding Full Table Scans”
Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.5, “Nested-Loop Join Algorithms”
C
[
index top
]
const
Section 8.8.2, “EXPLAIN Output Format”
Section 8.8.3, “Extended EXPLAIN Output Format”
Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 8.2.1.10, “ORDER BY Optimization”
Section 8.2.1.2, “Range Optimization”
Section 13.2.9, “SELECT Syntax”
E
[
index top
]
eq_ref
Section 8.8.2, “EXPLAIN Output Format”
Section 15.8.1, “MERGE Table Advantages and Disadvantages”
Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 8.2.2, “Subquery Optimization”
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.5, “Nested-Loop Join Algorithms”
index_merge
Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.3, “Index Merge Optimization”
index_subquery
Section 8.8.2, “EXPLAIN Output Format”
Section 13.2.10.10, “Optimizing Subqueries”
Section 8.2.2, “Subquery Optimization”
R
[
index top
]
range
Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.11, “GROUP BY Optimization”
Section 8.2.1.3, “Index Merge Optimization”
Section 8.2.1.5, “Nested-Loop Join Algorithms”
Section 8.2.1.2, “Range Optimization”
ref
Section 8.8.2, “EXPLAIN Output Format”
Section 8.8.3, “Extended EXPLAIN Output Format”
Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”
Section 15.8.1, “MERGE Table Advantages and Disadvantages”
Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 8.2.2, “Subquery Optimization”
ref_or_null
Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.9, “IS NULL Optimization”
Section 8.2.2, “Subquery Optimization”
S
[
index top
]
system
Section 8.8.2, “EXPLAIN Output Format”
Section 8.8.3, “Extended EXPLAIN Output Format”
Section 8.2.1.2, “Range Optimization”
Section 13.2.9, “SELECT Syntax”
U
[
index top
]
unique_subquery
Section 8.8.2, “EXPLAIN Output Format”
Section 13.2.10.10, “Optimizing Subqueries”
Section 8.2.2, “Subquery Optimization”