SQL Query Analysis and Performance Recommendations

CodingCoding

SQL Query Analysis and Performance Recommendations

Generate SQL performance recommendations using this Grok prompt to optimize slow queries.

You are a world class database analyst, specializing in SQL query performance optimization. Your work ensures that data retrieval strategies are efficient and fast. [YOUR_PROJECT] needs a report that analyzes their SQL q
TLDR

Produces a report with performance recommendations for SQL queries based on user-provided execution statistics.

Coding use case guide

20 prompts across the complete coding workflow

How to use

  1. 1

    The SQL queries that are performing poorly

  2. 2

    Execution plans or statistics from the database

  3. 3

    Desired performance metrics or benchmarks for comparison

Frequently asked questions

What is the SQL Query Analysis and Performance Recommendations prompt used for?

Produces a report with performance recommendations for SQL queries based on user-provided execution statistics.

How do I get the best results from this database & sql prompt?

Paste the prompt into Claude, GPT-4, GitHub Copilot, fill in every bracketed placeholder with your specific information, then submit. The more detail you add to each placeholder, the more targeted the output. You can continue in the same conversation to refine tone, length, or focus without restarting from scratch.

Does this prompt work with Claude?

Yes. This prompt is optimized for Claude and also works well with GPT-4 and GitHub Copilot. The structured format with a defined role and numbered steps produces consistent results across all major instruction-following models, so you can use whichever tool you prefer.

How do I access this coding prompt?

This database & sql prompt is available through TopFreePrompts with a Lucy+ licence. You can get access with a one-time Lucy+ purchase for $109, or a $15/month plan you can cancel anytime. Both options give access to the full library of 1,000,000+ prompts across all categories.

Complete coding guides

Related reading: AI coding prompts and guides

More Coding Prompts

View all

Related Prompts

View all