Join Types Index

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

A

[index top]

ALL

Section 7.2.2, “EXPLAIN Output Format”
Section 7.3.1.11, “How to Avoid Table Scans”
Section 7.3.1.6, “Nested-Loop Join Algorithms”

C

[index top]

const

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.3.12, “Changes in Release 3.23.48 (07 February 2002)”
Section C.2.22, “Changes in Release 4.0.10 (29 January 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 7.2.2, “EXPLAIN Output Format”
Section 7.3.1.7, “ORDER BY Optimization”
Section 12.2.7, “SELECT Syntax”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”

E

[index top]

eq_ref

Section 7.2.2, “EXPLAIN Output Format”
Section 13.3.1, “MERGE Table Advantages and Disadvantages”

F

[index top]

fulltext

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section 7.2.2, “EXPLAIN Output Format”

I

[index top]

index

Section 7.2.2, “EXPLAIN Output Format”
Section 7.3.1.6, “Nested-Loop Join Algorithms”

index_subquery

Section 7.2.2, “EXPLAIN Output Format”
Section 12.2.8.10, “Optimizing Subqueries”

R

[index top]

range

Section C.3.59, “Changes in Release 3.23.2 (09 August 1999)”
Section 7.2.2, “EXPLAIN Output Format”
Section 7.3.1.6, “Nested-Loop Join Algorithms”
Section 7.3.1.3, “Range Optimization”

ref

Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.3.59, “Changes in Release 3.23.2 (09 August 1999)”
Section 7.2.2, “EXPLAIN Output Format”
Section 13.3.1, “MERGE Table Advantages and Disadvantages”
Section 7.4.4, “MyISAM Index Statistics Collection”

ref_or_null

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section 7.2.2, “EXPLAIN Output Format”
Section 7.3.1.4, “IS NULL Optimization”

S

[index top]

system

Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section 7.2.2, “EXPLAIN Output Format”
Section 15.5.6.1, “MySQL Cluster: Messages in the Cluster Log”
Section 12.2.7, “SELECT Syntax”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”

U

[index top]

unique_subquery

Section 7.2.2, “EXPLAIN Output Format”
Section 12.2.8.10, “Optimizing Subqueries”