JOIN Types Index
Prev   Next

JOIN Types Index

ALL

Section 7.13.11.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 7.13.7, “Nested-Loop Join Algorithms”

const

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.12, “ORDER BY Optimization”
Section 12.2.9, “SELECT Syntax”
Section 7.13.1.1, “The Range Access Method for Single-Part Indexes”

eq_ref

Section 7.8.2, “EXPLAIN Output Format”
Section 13.8.1, “MERGE Table Advantages and Disadvantages”
Section 7.13.4, “Index Condition Pushdown Optimization”
Section 7.13.15, “Optimizing IN/=ANY Subqueries”

fulltext

Section 7.8.2, “EXPLAIN Output Format”

index

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.11.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 7.13.7, “Nested-Loop Join Algorithms”

index_merge

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.2, “Index Merge Optimization”

index_subquery

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.15, “Optimizing IN/=ANY Subqueries”
Section 12.2.10.10, “Optimizing Subqueries”

range

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.11.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 7.13.4, “Index Condition Pushdown Optimization”
Section 7.13.2, “Index Merge Optimization”
Section 7.13.13.1, “Loose Index Scan”
Section 7.13.7, “Nested-Loop Join Algorithms”
Section 7.13.1, “Range Optimization”
Section 7.13.1.1, “The Range Access Method for Single-Part Indexes”

ref

Section 7.8.2, “EXPLAIN Output Format”
Section 13.8.1, “MERGE Table Advantages and Disadvantages”
Section 7.3.7, “InnoDB and MyISAM Index Statistics Collection”
Section 7.13.4, “Index Condition Pushdown Optimization”
Section 7.13.15, “Optimizing IN/=ANY Subqueries”

ref_or_null

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.5, “IS NULL Optimization”
Section 7.13.4, “Index Condition Pushdown Optimization”
Section 7.13.15, “Optimizing IN/=ANY Subqueries”

system

Section 7.8.2, “EXPLAIN Output Format”
Section 12.2.9, “SELECT Syntax”
Section 7.13.1.1, “The Range Access Method for Single-Part Indexes”

unique_subquery

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.15, “Optimizing IN/=ANY Subqueries”
Section 12.2.10.10, “Optimizing Subqueries”
Copyright © 1997, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices
Prev   Next
Transaction Isolation Level Index Home Operator Index