Prompt to Optimize a Slow SQL Query (Free Copy-Paste Prompt)

Copy-ready prompt

Optimize this slow SQL query for [database].
```
[paste query]
```
Schema and sizes: [tables, row counts, existing indexes].
Requirements:
- Explain what's likely making it slow.
- Suggest index changes and query rewrites.
- Provide an optimized version.
- Note trade-offs of each suggestion.

Want a version tailored to you?

Answer a few quick questions and the SQL Query Generator builds a custom prompt from your exact details.

🗄️ Open the SQL Query Generator

Why this prompt works

Query tuning depends on schema, data volume, and indexes — details the AI can't guess. Provide them and this prompt can pinpoint the bottleneck and propose rewrites plus indexes, with trade-offs so you don't fix speed at the cost of write performance.

How to customize it

Include row counts and existing indexes; they drive the diagnosis.
Test suggested indexes on a copy — they add write overhead.
Compare execution plans before and after.

Tip: replace the parts in [square brackets] with your own details before you send. The more specific you are — audience, tone, goal, constraints — the better the AI output.