mysql 存在索引但不能使用索引的典型场景
https://www.cnblogs.com/dsitn/p/7091283.html
MySQL的语句执行顺序
https://www.cnblogs.com/rollenholt/p/3776923.html
MySQL 索引的原理与应用:索引类型,存储结构与锁
https://segmentfault.com/a/1190000019366328?utm_source=tag-newest
《Oracle SQL优化基础》之索引
https://ask.hellobi.com/blog/azzo/2065
MySQL优化常见Extra分析——慢查询优化
https://www.cnblogs.com/linjiqin/p/11254247.html
sql的Hint
https://my.oschina.net/91jason/blog/834644
Mysql-explain之Using temporary和Using filesort解决方案
https://www.cnblogs.com/fuhui-study-footprint/p/11648185.html