> For the complete documentation index, see [llms.txt](https://tuonioooo-notebook.gitbook.io/performance-optimization/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://tuonioooo-notebook.gitbook.io/performance-optimization/sqlyou-hua-pian/mysqlyou-hua-pian/xiang-jie-suo-yin-ji-you-hua.md).

# 详解索引及优化

* [索引优缺点](/performance-optimization/sqlyou-hua-pian/mysqlyou-hua-pian/xiang-jie-suo-yin-ji-you-hua/suo-yin-you-que-dian.md)
* [索引种类](/performance-optimization/sqlyou-hua-pian/mysqlyou-hua-pian/xiang-jie-suo-yin-ji-you-hua/suo-yin-zhong-lei.md)
* [不走索引的情况](/performance-optimization/sqlyou-hua-pian/mysqlyou-hua-pian/xiang-jie-suo-yin-ji-you-hua/bu-zou-suo-yin-de-qing-kuang.md)
* [索引实现分析](/performance-optimization/sqlyou-hua-pian/mysqlyou-hua-pian/xiang-jie-suo-yin-ji-you-hua/suo-yin-shi-xian-fen-xi.md)
* [高性能前缀索引](/performance-optimization/sqlyou-hua-pian/mysqlyou-hua-pian/xiang-jie-suo-yin-ji-you-hua/gao-xing-neng-qian-zhui-suo-yin.md)