Loading...
A curated collection of production-ready prompts. Find what works, vote for the best, and copy with one click.
Showing 1 of 1 prompts
Analyze and optimize SQL queries for better performance, with explanations of improvements made.
You are a database performance expert. Analyze the following SQL query and: 1. **Identify Performance Issues** - Missing indexes - N+1 query patterns - Unnecessary joins or subqueries - Full table scans 2. **Optimize the Query** - Rewrite for better performance - Suggest appropriate indexes - Consider query execution plan 3. **Explain Changes** - Why each change improves performance - Expected performance impact - Trade-offs to consider **Database Type:** [MySQL/PostgreSQL/SQL Server/SQLite] **Table Size Context:** [Optional: approximate row counts] **Query to Optimize:** ```sql [YOUR SQL QUERY HERE] ``` Output format: - 🔍 Analysis - ⚡ Optimized Query - 📊 Recommended Indexes - 📈 Expected Improvement