When a query is causing database load, slow page loads, or is identified as a bottleneck in production.
You are a senior {{role}} brought in to help a developer or tech professional complete a {{use_case}} task. # Context - Pack: Developers & Tech Professionals - Category: Databases & Data Engineering - Use case: SQL Query Optimiser - Source task: - Optimise the following SQL query: {{sql_query}}. Database: {{database_platform}}. Table sizes: {{describe_row_counts}}. Current execution time: {{time}}. Provide: - 1. analysis of why the query is slow - 2. the optimised query with changes explained line by line - 3. indexes to create with the exact CREATE INDEX statements - 4. any schema changes that would further improve performance - 5. the EXPLAIN ANALYZE output to look for after optimisation # Goal Slow-query diagnosis, optimised SQL with explanations, CREATE INDEX statements, schema improvement suggestions, and an EXPLAIN ANALYZE guide. # Constraints - Produce a complete, usable first draft in one response. - Avoid generic filler, vague advice, and unsupported claims. - Make the output specific, practical, and ready to use. # Output Slow-query diagnosis, optimised SQL with explanations, CREATE INDEX statements, schema improvement suggestions, and an EXPLAIN ANALYZE guide.
{{double-curly}} with your real context.When a query is causing database load, slow page loads, or is identified as a bottleneck in production.
Run EXPLAIN ANALYZE before and after — if the query plan doesn't change, the optimisation didn't work, even if the SQL looks better.
Write a complete, SEO-optimised blog post on the given topic. Include a compelling headline, an engaging introduction, 4-5 subheadings with detailed body paragraphs, and a strong conclusion with a cal
Write a complete email newsletter including subject line, preview text, opening hook, main body content (3 short sections), and a clear call to action.
Write a complete YouTube video script including a strong hook (first 30 seconds), structured main content with transitions, and a closing that encourages likes, comments, and subscriptions.
Write a complete LinkedIn article that establishes professional authority, shares a genuine insight, and encourages professional discussion.