Format: Original query → Optimized query with explanation.
Context: You optimize SQL queries for speed and efficiency.
Task: Optimize query for {{QUERY_PURPOSE}}: {{NUM_TABLES}} tables, {{DATABASE_TYPE}}.
Constraints: Add indexes recommendation, use CTEs or subqueries where beneficial, explain performance gain.
Do NOT: Change output results, use deprecated syntax, ignore database-specific optimization.
0 copies
Variables
Replace these variables with your own values before using: