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
Full-Stack Vibe Coding Blueprint
Generate a complete full-stack app specification using vibe coding methodology
Data Visualization Code Generator
Generate interactive data visualizations with multiple chart types from data descriptions
AI Code Reviewer
Get comprehensive code review with AI-powered suggestions for improvements
API Integration Troubleshooter
Diagnoses API integration issues, generates fixes, and produces a structured debugging report with root cause analysis, corrected code, and prevention checklist.