JOIN Types Index
Prev   Next

JOIN Types Index

ALL

Section 7.2.11, “Nested-Loop Join Algorithms”

const

Section 7.2.14, “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 13.8.1, “MERGE Table Advantages and Disadvantages”
Section 7.2.8, “Index Condition Pushdown Optimization”
Section 7.2.17, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN”

fulltext

Section 7.2.1, “Optimizing Queries with EXPLAIN”

index

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.17, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 12.2.10.10, “Optimizing Subqueries”

range

Section 7.2.8, “Index Condition Pushdown Optimization”
Section 7.2.6, “Index Merge Optimization”
Section 7.2.15.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 13.8.1, “MERGE Table Advantages and Disadvantages”
Section 7.4.7, “MyISAM Index Statistics Collection”
Section 7.2.8, “Index Condition Pushdown Optimization”
Section 7.2.17, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN”

ref_or_null

Section 7.2.9, “IS NULL Optimization”
Section 7.2.8, “Index Condition Pushdown Optimization”
Section 7.2.17, “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.17, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 12.2.10.10, “Optimizing Subqueries”
Prev   Next
Transaction Isolation Level Index Home Operator Index