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
API Documentation Generator
Generate comprehensive API documentation from code or specifications
Edge Case Explorer
Generate comprehensive edge cases and boundary condition tests for any system
Tree of Thoughts Problem Solver
A prompt technique that explores multiple reasoning paths simultaneously, generating and evaluating different thought branches to find optimal solutions.
AI Code Reviewer
Get comprehensive code review with AI-powered suggestions for improvements