JOIN Types Index
   

JOIN Types Index

ALL

Section 7.13.6, “Nested-Loop Join Algorithms”

const

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.9, “ORDER BY Optimization”
Section 12.2.9, “SELECT Синтаксис”
Section 16.3.4.3, “MySQL Cluster System Variables”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”

eq_ref

Section 7.8.2, “EXPLAIN Output Format”
Section 13.10.1, “MERGE Table Advantages and Disadvantages”
Section 16.3.4.3, “MySQL Cluster System Variables”
Section 7.13.12, “Optimizing IN/=ANY Subqueries”

fulltext

Section 7.8.2, “EXPLAIN Output Format”

index

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.6, “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.12, “Optimizing IN/=ANY Subqueries”
Section 12.2.10.10, “Optimizing Subqueries”

range

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.2, “Index Merge Optimization”
Section 7.13.10.1, “Loose Index Scan”
Section 7.13.6, “Nested-Loop Join Algorithms”
Section 7.13.1, “Range Optimization”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”

ref

Section 7.8.2, “EXPLAIN Output Format”
Section 7.3.7, “InnoDB and MyISAM Index Statistics Collection”
Section 13.10.1, “MERGE Table Advantages and Disadvantages”
Section 16.3.4.3, “MySQL Cluster System Variables”
Section 7.13.12, “Optimizing IN/=ANY Subqueries”

ref_or_null

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.4, “IS NULL Optimization”
Section 7.13.12, “Optimizing IN/=ANY Subqueries”

system

Section 7.8.2, “EXPLAIN Output Format”
Section 12.2.9, “SELECT Синтаксис”
Section 16.5.6.1, “MySQL Cluster: Messages in the Cluster Log”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”

unique_subquery

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.12, “Optimizing IN/=ANY Subqueries”
Section 12.2.10.10, “Optimizing Subqueries”
Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices
   
Transaction Isolation Level Index Начало Operator Index
    Поддержать сайт на родительском проекте КГБ