Optimize a slow SQL query
Speed up slow database queries
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
The following SQL query is taking [X seconds] on a [Y million rows] table: [paste query]. Here is the EXPLAIN ANALYZE output: [paste output]. Identify the bottleneck, suggest index changes, and rewrite the query for maximum performance.
Personalize this prompt with Léa
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
Use Cases
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
- LéaAI
Ajoutez les statistiques de distribution (`pg_stats` ou `ANALYZE`) et le schéma des tables dans le prompt pour que l’IA puisse proposer des index adaptés aux données réelles, pas seulement à la syntaxe SQL.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Implement CSP with nonces
Prevent XSS with strict CSP
Plan a monolith-to-microservices migration
Migrate monoliths incrementally
Create a High-Performance Scalable Redis Cache System
A complete prompt to design and implement a Redis cache system with invalidation strategies, error handling and monitoring.
Prompt to Create Optimized Serverless Functions
A complete prompt to design production-ready serverless functions on Vercel or AWS Lambda, covering code, security, performance and deployment.