# 查询优化

- [优化 SQL 语句的一般步骤](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/you-hua-sql-yu-ju-de-yi-ban-bu-zhou.md)
- [1. 通过 show status 命令了解各种 SQL 的执行频率](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/you-hua-sql-yu-ju-de-yi-ban-bu-zhou/1.-tong-guo-show-status-ming-ling-liao-jie-ge-zhong-sql-de-zhi-xing-pin-l.md)
- [2. 定位执行效率较低的 SQL 语句](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/you-hua-sql-yu-ju-de-yi-ban-bu-zhou/2.-ding-wei-zhi-xing-xiaoljiao-di-de-sql-yu-ju.md)
- [3. 通过 EXPLAIN 分析低效 SQL 的执行计划](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/you-hua-sql-yu-ju-de-yi-ban-bu-zhou/3.-tong-guo-explain-fen-xi-di-xiao-sql-de-zhi-xing-ji-hua.md)
- [4. 通过 SHOW PROFILE 分析 SQL](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/you-hua-sql-yu-ju-de-yi-ban-bu-zhou/4.-tong-guo-show-profile-fen-xi-sql.md)
- [5. 通过 TRACE 分析优化器如何选择执行计划](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/you-hua-sql-yu-ju-de-yi-ban-bu-zhou/5.-tong-guo-trace-fen-xi-you-hua-qi-ru-he-xuan-ze-zhi-xing-ji-hua.md)
- [6. 确定问题并采取相应的优化措施](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/you-hua-sql-yu-ju-de-yi-ban-bu-zhou/6.-que-ding-wen-ti-bing-cai-qu-xiang-ying-de-you-hua-cuo-shi.md)
- [两个简单实用的优化方法](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/liang-ge-jian-dan-shi-yong-de-you-hua-fang-fa.md)
- [一个复杂查询还是多个简单查询](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/yi-ge-fu-za-cha-xun-hai-shi-duo-ge-jian-dan-cha-xun.md)
- [常用 SQL 的优化](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/chang-yong-sql-de-you-hua.md)
- [大批量插入数据](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/chang-yong-sql-de-you-hua/da-pi-liang-cha-ru-shu-ju.md)
- [优化 GROUP BY 语句](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/chang-yong-sql-de-you-hua/you-hua-group-by-yu-ju.md)
- [优化联接查询](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/chang-yong-sql-de-you-hua/you-hua-lian-jie-cha-xun.md)
- [优化分页查询](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/chang-yong-sql-de-you-hua/you-hua-fen-ye-cha-xun.md)
- [优化 SQL\_CALC\_FOUND\_ROWS](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/chang-yong-sql-de-you-hua/you-hua-sqlcalcfoundrows.md)
- [优化 UNION 查询](/ji-chu/mysql/sql-you-hua/cha-xun-you-hua/chang-yong-sql-de-you-hua/you-hua-union-cha-xun.md)
