Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Ming的博客 | Ming的博客 #11

Open
heyanming opened this issue Apr 28, 2024 · 0 comments
Open

Ming的博客 | Ming的博客 #11

heyanming opened this issue Apr 28, 2024 · 0 comments
Labels
2e3994ba3acf9f05332e4ce7eae5a102 Gitalk

Comments

@heyanming
Copy link
Owner

https://kingfried.cn/posts/0/

执行计划了解查询执行计划根据表、列、索引的详细信息以及子句中的条件WHERE，MySQL 优化器会考虑多种技术来有效地执行 SQL 查询中涉及的查找。对大表进行查询无需读取所有行；可以执行涉及多个表的联接，而无需比较每个行组合。优化器选择执行最高效查询的操作集称为“查询执行计划”，也称为 EXPLAIN计划。您的目标是认识计划中表明查询优化良好的方面 EXPLAIN，并学习 SQL 语法和索引技术
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
2e3994ba3acf9f05332e4ce7eae5a102 Gitalk
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@heyanming