“等值最左,范围跟上,覆盖殿后,回表清零。” —— SQL优化口诀 #183

Open
opened 2025-12-22 20:38:51 +08:00 by bigtran · 0 comments
Owner

等值 =
范围 > < BETWEEN LIKE
覆盖 select、where、order by字段

二级索引包含查询所需的所有列(SELECT + WHERE + ORDER BY),引擎不必回表

等值 = 范围 > < BETWEEN LIKE 覆盖 select、where、order by字段 二级索引包含查询所需的所有列(SELECT + WHERE + ORDER BY),引擎不必回表
bigtran added the 4-document label 2025-12-22 20:39:01 +08:00
bigtran added the 6-now-commit-to-fix label 2025-12-27 22:36:59 +08:00
Sign in to join this conversation.