SQL Query Optimizer

Prompt

Optimize this SQL query for performance:
```sql
[query]
```
Schema context: [table structures, approximate row counts, existing indexes]

Provide: (1) Explain plan analysis of the original. (2) Identified bottlenecks. (3) Optimized query with comments. (4) Index recommendations with CREATE INDEX statements. (5) Expected performance improvement. (6) Alternative approaches if applicable.

How to use this prompt

1. 1

   Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.

2. 2

   Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.

3. 3

   Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.

Techniques in this prompt

Recommended models