temp-tickets/tickets
10
0
Code Issues 453 Packages Projects 4 Wiki

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

New Issue
Open
opened 2025-12-22 20:38:51 +08:00 by bigtran · 0 comments
bigtran commented 2025-12-22 20:38:51 +08:00
Owner
Copy Link
Copy Source

等值 =
范围 > < 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.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
1-feature
2-bug
Something is not working
 3-enhancement
New feature
 4-document
5-bloody-version-diff
搞死人的版本差异
 6-now-commit-to-fix
下定决心解决，用行动证明，用结果证明
 duplicate
This issue or pull request already exists
 invalid
Something is wrong
 wontfix
This won't be fixed
No Label 4-document 6-now-commit-to-fix
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
bigtran (张大川) chenyingjie fanjc huangyanxue liuning panzs qilisong yanyanyan
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: temp-tickets/tickets#183
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?