SQL Query Performance Optimizer
Analyze and optimize SQL queries for better performance with index suggestions and query restructuring.
Content
Analyze and optimize the following SQL query: Database: {{database_type}} Query: {{sql_query}} Current Performance Issues: {{issues}} Provide: 1. **Performance Analysis**: Explain what the query does and potential bottlenecks 2. **Optimization Recommendations**: Specific changes to improve performance 3. **Index Suggestions**: New indexes that would help 4. **Rewritten Query**: An optimized version of the query 5. **Execution Plan Explanation**: What the query plan shows 6. **Alternatives**: Different approaches if applicable Focus on practical improvements that will have measurable impact.
Related Prompts
Chain-of-Thought Debugger
Step-by-step code debugging prompt that asks AI to think through the problem before providing solutions
Chain-of-Thought Reasoning
Step-by-step reasoning prompt for complex problem solving
Code Explainer Pro
Explain any code snippet in simple terms with line-by-line analysis, time complexity, and practical examples.
API Documentation Generator
Generate comprehensive API documentation from code or specifications