Íîâîñòè
Äîêóìåíòàöèÿ
Download
Webboard
Ïîèñê
FAQ/×àÂî
Îáðàòíàÿ ñâÿçü

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.3.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.3.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 17.5.5.1, “MySQL Cluster — Messages in the Cluster Log”
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”
Prev   Next
Transaction Isolation Level Index Home Operator Index



ÐÅÊËÀÌÀ ÍÀ ÑÀÉÒÅ
  Ñîçäàíèå ñàéòîâ | |