Free
1,339 uses
Optimize slow SQL queries for better database performance.
Prompt
Optimize the following SQL query that is running slowly on a [PostgreSQL/MySQL/SQL Server] database: ```sql [paste your slow query here] ``` Table sizes: [table1: X rows], [table2: Y rows]. Current execution time: [X seconds]. Analyze: query execution plan issues, missing indexes, N+1 problem, unnecessary subqueries, JOIN optimization opportunities. Provide: optimized query, index recommendations (CREATE INDEX statements), explanation of changes, and expected performance improvement.
Paste directly into Claude · Replace text in [brackets] with your own info
Free template suggestion
If this prompt is close but not exactly what you need, leave a topic suggestion. We use repeated requests to expand the free prompt library.
Best for readers who want the free library to cover a specific workflow or niche.
Before you use this prompt
This free prompt is a starting point, not a finished deliverable. Review the result, remove sensitive information, and adapt the wording before you publish, send, or rely on it.
✓ Replace every bracketed placeholder with your own context before running it.
✓ Remove private customer data, passwords, personal addresses, and unpublished business details.
✓ Check facts, numbers, claims, and links before publishing or sending the output.
✓ Edit the tone so it matches your brand, audience, and local market.
✓ Do not present AI output as legal, medical, financial, or guaranteed professional advice.
✓ Save the best version so you can reuse and improve it next time.
Enter your topic — AI fills the prompt and shows a live sample
See what others created with this prompt
No results yet — be the first to share!
Explore related templates
If this prompt is useful, the fastest next step is to open a few related templates, compare the wording, and keep the version that best matches your workflow.