2428424081cn SQL 性能优化与索引调优指南
常见慢查询反模式与优化方案
- 避免
SELECT *：仅投影业务所需列，利于覆盖索引（Covering Index）。 - 大偏移量深度分页优化：使用延迟关联或游标式分页代替
LIMIT 1000000, 20。 - 模糊搜索前缀匹配：
LIKE '%abc'无法走索引，建议全文索引或前缀索引。
SQL Query Optimizer by 2428424081cn · 86e07b9
npx skillmds@latest add 2428424081cn/sql-query-optimizer File contents
---name: sql-query-optimizerdescription: SQL 性能优化与慢查询诊断。提供索引覆盖（Covering Index）、分页深度优化与 JOIN 性能建议。---# SQL 性能优化与索引调优指南## 常见慢查询反模式与优化方案1. **避免 `SELECT *`**：仅投影业务所需列，利于覆盖索引（Covering Index）。2. **大偏移量深度分页优化**：使用延迟关联或游标式分页代替 `LIMIT 1000000, 20`。3. **模糊搜索前缀匹配**：`LIKE '%abc'` 无法走索引，建议全文索引或前缀索引。
2428424081cn/Skill-mcp/tree/main/skills/data/sql-query-optimizer commit 86e07b930e
Frequently asked questions
Run npx skillmds@latest add 2428424081cn/sql-query-optimizer in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
SQL 性能优化与慢查询诊断。提供索引覆盖（Covering Index）、分页深度优化与 JOIN 性能建议。 It is listed under Data & Analytics on SkillMD.
This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
2428424081cn (@2428424081cn) published this skill. Their other Agent Skills are listed on their SkillMD profile.