A

[index top]

ALL

Section 9.2.1.19, “Avoiding Full Table Scans”

Section 9.2.1.11.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”

Section 9.8.2, “EXPLAIN Output Format”

Section 9.2.1.6, “Nested-Loop Join Algorithms”

C

[index top]

const

Section 9.8.2, “EXPLAIN Output Format”

Section 9.8.3, “Extended EXPLAIN Output Format”

Section 21.3.3.8.2, “NDB Cluster System Variables”

Section 9.2.1.13, “ORDER BY Optimization”

Section 14.2.9, “SELECT Syntax”

Section 9.2.1.2.1, “The Range Access Method for Single-Part Indexes”

E

[index top]

eq_ref

Section 9.2.1.11.3, “Batched Key Access Joins”

Section 9.8.2, “EXPLAIN Output Format”

Section 9.2.1.5, “Index Condition Pushdown Optimization”

Section 16.7.1, “MERGE Table Advantages and Disadvantages”

Section 21.3.3.8.2, “NDB Cluster System Variables”

Section 9.2.2.4, “Optimizing Subqueries with the EXISTS Strategy”

Section 25.10.4.1, “The events_waits_current Table”

F

[index top]

fulltext

Section 9.8.2, “EXPLAIN Output Format”

I

[index top]

index

Section 9.2.1.11.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”

Section 9.8.2, “EXPLAIN Output Format”

Section 9.2.1.6, “Nested-Loop Join Algorithms”

index_merge

Section 9.8.2, “EXPLAIN Output Format”

Section 9.2.1.3, “Index Merge Optimization”

index_subquery

Section 9.8.2, “EXPLAIN Output Format”

Section 14.2.10.10, “Optimizing Subqueries”

Section 9.2.2.4, “Optimizing Subqueries with the EXISTS Strategy”

R

[index top]

range

Section 9.2.1.11.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”

Section 9.8.2, “EXPLAIN Output Format”

Section 9.2.1.14, “GROUP BY Optimization”

Section 9.2.1.5, “Index Condition Pushdown Optimization”

Section 9.2.1.3, “Index Merge Optimization”

Section 9.2.1.6, “Nested-Loop Join Algorithms”

Section 9.2.1.2, “Range Optimization”

Section 9.2.1.2.1, “The Range Access Method for Single-Part Indexes”

ref

Section 9.2.1.11.3, “Batched Key Access Joins”

Section 9.8.2, “EXPLAIN Output Format”

Section 9.8.3, “Extended EXPLAIN Output Format”

Section 9.2.1.5, “Index Condition Pushdown Optimization”

Section 9.3.7, “InnoDB and MyISAM Index Statistics Collection”

Section 16.7.1, “MERGE Table Advantages and Disadvantages”

Section 21.3.3.8.2, “NDB Cluster System Variables”

Section 9.2.2.3, “Optimizing Derived Tables and View References”

Section 9.2.2.4, “Optimizing Subqueries with the EXISTS Strategy”

ref_or_null

Section 9.8.2, “EXPLAIN Output Format”

Section 9.2.1.5, “Index Condition Pushdown Optimization”

Section 9.2.1.12, “IS NULL Optimization”

Section 9.2.2.4, “Optimizing Subqueries with the EXISTS Strategy”

S

[index top]

system

Section 9.8.2, “EXPLAIN Output Format”

Section 9.8.3, “Extended EXPLAIN Output Format”

Section 14.2.9, “SELECT Syntax”

Section 9.2.1.2.1, “The Range Access Method for Single-Part Indexes”

U

[index top]

unique_subquery

Section 9.8.2, “EXPLAIN Output Format”

Section 14.2.10.10, “Optimizing Subqueries”

Section 9.2.2.4, “Optimizing Subqueries with the EXISTS Strategy”