A

[]

ALL

Section 10.2.1.23, “避免全表扫描”

Section 10.2.1.12, “块嵌套循环和批量键访问连接”

Section 10.8.2, “EXPLAIN 输出格式”

Section 10.2.1.7, “嵌套循环连接算法”

C

[]

const

Section 10.8.2, “EXPLAIN 输出格式”

Section 10.8.3, “Extended EXPLAIN 输出格式”

Section 10.9.3, “优化器提示”

Section 10.2.1.16, “ORDER BY 优化”

Section 10.2.1.2, “Range 优化”

Section 15.2.13, “选择语句”

E

[]

eq_ref

Section 10.2.1.12, “块嵌套循环和批量键访问连接”

Section 10.8.2, “EXPLAIN 输出格式”

Section 10.2.1.6, “Index Condition Pushdown 优化”

Section 18.7.1, “MERGE 表的优点和缺点”

Section 10.2.2.3, “优化子查询 with the EXISTS Strategy”

Section 29.12.4.1, “events_waits_current 表”

F

[]

fulltext

Section 10.8.2, “EXPLAIN 输出格式”

I

[]

index

Section 10.2.1.12, “块嵌套循环和批量键访问连接”

Section 10.8.2, “EXPLAIN 输出格式”

Section 10.2.1.7, “嵌套循环连接算法”

index_merge

Section 10.8.2, “EXPLAIN 输出格式”

Section 10.2.1.3, “Index Merge 优化”

index_subquery

Section 10.8.2, “EXPLAIN 输出格式”

Section 10.2.2.3, “优化子查询 with the EXISTS Strategy”

R

[]

range

Section 10.2.1.12, “块嵌套循环和批量键访问连接”

Section 10.8.2, “EXPLAIN 输出格式”

Section 10.2.1.17, “GROUP BY 优化”

Section 10.2.1.6, “Index Condition Pushdown 优化”

Section 10.2.1.3, “Index Merge 优化”

Section 10.2.1.7, “嵌套循环连接算法”

Section 10.9.3, “优化器提示”

Section 10.2.1.2, “Range 优化”

ref

Section 10.2.1.12, “块嵌套循环和批量键访问连接”

Section 10.8.2, “EXPLAIN 输出格式”

Section 10.8.3, “Extended EXPLAIN 输出格式”

Section 10.2.1.6, “Index Condition Pushdown 优化”

Section 10.3.8, “InnoDB和MyISAM索引统计信息收集”

Section 18.7.1, “MERGE 表的优点和缺点”

Section 10.9.3, “优化器提示”

Section 10.2.2.4, “Optimizing 派生表, View References, and Common Table Expressions with Merging or Materialization”

Section 10.2.2.3, “优化子查询 with the EXISTS Strategy”

ref_or_null

Section 10.8.2, “EXPLAIN 输出格式”

Section 10.2.1.6, “Index Condition Pushdown 优化”

Section 10.2.1.15, “IS NULL 优化”

Section 10.2.2.3, “优化子查询 with the EXISTS Strategy”

S

[]

system

Section 10.8.2, “EXPLAIN 输出格式”

Section 10.8.3, “Extended EXPLAIN 输出格式”

Section 10.2.1.2, “Range 优化”

Section 15.2.13, “选择语句”

U

[]

unique_subquery

Section 10.8.2, “EXPLAIN 输出格式”

Section 10.2.2.3, “优化子查询 with the EXISTS Strategy”