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 {{target_user}} complete a SQL Query Optimiser. # Context Original working context: Act as a database performance expert. Optimise the following SQL query: {{paste_query}}. Database: {{postgresql_mysql_sql_server_bigquery}}. 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 Produce the exact deliverable requested for this use-case. Make the output practical, specific, and ready to use. # Constraints - Use the user's variables exactly where relevant. - Avoid generic filler and vague advice. - Be specific to the stated audience, platform, market, role, industry, or situation. - Ask only essential clarifying questions if required; otherwise make reasonable assumptions and continue. # Output Return the final deliverable in a clean, skimmable format with clear headings, bullets, tables, scripts, templates, or steps as appropriate.
{{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.