Join Types Index

Join Types Index

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

A

[ index top]

ALL

Section 10.2.1.23, “Avoiding Full Table Scans”
Section 10.2.1.12, “Block Nested-Loop and Batched Key Access Joins”
Section 10.8.2, “EXPLAIN Output Format”

C

[ index top]

const

Section 10.8.2, “EXPLAIN Output Format”
Section 10.8.3, “Extended EXPLAIN Output Format”
Section 25.4.3.9.2, “NDB Cluster System Variables”
Section 10.9.3, “Optimizer Hints”
Section 10.2.1.16, “ORDER BY Optimization”
Section 10.2.1.2, “Range Optimization”
Section 15.2.13, “SELECT Statement”

E

[ index top]

eq_ref

Section 10.2.1.12, “Block Nested-Loop and Batched Key Access Joins”
Section 10.8.2, “EXPLAIN Output Format”
Section 10.2.1.6, “Index Condition Pushdown Optimization”
Section 18.7.1, “MERGE Table Advantages and Disadvantages”
Section 25.4.3.9.2, “NDB Cluster System Variables”
Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
Section 29.12.4.1, “The events_waits_current Table”

F

[ index top]

fulltext

Section 10.8.2, “EXPLAIN Output Format”

I

[ index top]

index

Section 10.2.1.12, “Block Nested-Loop and Batched Key Access Joins”
Section 10.8.2, “EXPLAIN Output Format”

index_merge

Section 10.8.2, “EXPLAIN Output Format”
Section 10.2.1.3, “Index Merge Optimization”

index_subquery

Section 10.8.2, “EXPLAIN Output Format”
Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”

R

[ index top]

range

Section 10.2.1.12, “Block Nested-Loop and Batched Key Access Joins”
Section 10.8.2, “EXPLAIN Output Format”
Section 10.2.1.17, “GROUP BY Optimization”
Section 10.2.1.6, “Index Condition Pushdown Optimization”
Section 10.2.1.3, “Index Merge Optimization”
Section 10.9.3, “Optimizer Hints”
Section 10.2.1.2, “Range Optimization”

ref

Section 10.2.1.12, “Block Nested-Loop and Batched Key Access Joins”
Section 10.8.2, “EXPLAIN Output Format”
Section 10.8.3, “Extended EXPLAIN Output Format”
Section 10.2.1.6, “Index Condition Pushdown Optimization”
Section 10.3.8, “InnoDB and MyISAM Index Statistics Collection”
Section 18.7.1, “MERGE Table Advantages and Disadvantages”
Section 25.4.3.9.2, “NDB Cluster System Variables”
Section 10.9.3, “Optimizer Hints”
Section 10.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”
Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”

ref_or_null

Section 10.8.2, “EXPLAIN Output Format”
Section 10.2.1.6, “Index Condition Pushdown Optimization”
Section 10.2.1.15, “IS NULL Optimization”
Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”

S

[ index top]

system

Section 10.8.2, “EXPLAIN Output Format”
Section 10.8.3, “Extended EXPLAIN Output Format”
Section 10.2.1.2, “Range Optimization”
Section 15.2.13, “SELECT Statement”

U

[ index top]

unique_subquery

Section 10.8.2, “EXPLAIN Output Format”
Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”