MySQL 5.6 Release Notes
ALL
const
eq_ref
- Section 8.2.1.11, “Block Nested-Loop and Batched Key Access Joins”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 8.2.1.5, “Index Condition Pushdown Optimization”
- Section 15.7.1, “MERGE Table Advantages and Disadvantages”
- Section 18.4.3.8.2, “NDB Cluster System Variables”
- Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
index
index_subquery
range
- Section 8.2.1.11, “Block Nested-Loop and Batched Key Access Joins”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 8.2.1.14, “GROUP BY Optimization”
- Section 8.2.1.5, “Index Condition Pushdown Optimization”
- Section 8.2.1.3, “Index Merge Optimization”
- Section 8.2.1.6, “Nested-Loop Join Algorithms”
- Section 8.2.1.2, “Range Optimization”
ref
- Section 8.2.1.11, “Block Nested-Loop and Batched Key Access Joins”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 8.8.3, “Extended EXPLAIN Output Format”
- Section 8.2.1.5, “Index Condition Pushdown Optimization”
- Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”
- Section 15.7.1, “MERGE Table Advantages and Disadvantages”
- Section 18.4.3.8.2, “NDB Cluster System Variables”
- Section 8.2.2.4, “Optimizing Derived Tables”
- Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”