JOIN Types Index
Prev Next

JOIN Types Index

ALL

Section 7.2.10, “Nested-Loop Join Algorithms”

const

Section 7.2.13, “ORDER BY Optimization”
Section 12.2.8, “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.16, “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.10, “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.16, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 12.2.9.10, “Optimizing Subqueries”

range

Section 7.2.6, “Index Merge Optimization”
Section 7.2.14.1, “Loose Index Scan”
Section 7.2.10, “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.16, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN”

ref_or_null

Section 7.2.8, “IS NULL Optimization”
Section 7.2.16, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN”

system

Section 12.2.8, “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.16, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 12.2.9.10, “Optimizing Subqueries”
Copyright © 1997, 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices
Prev Next
Transaction Isolation Level Index Home Operator Index