prompt

SQL Query Optimizer

Analyze query performance bottlenecks and recommend indexing, partitioning, or join reordering strategies.

Updated June 2026

The prompt

I have a {{query_description}} query on {{table_count}} tables ({{total_rows}} rows total) that runs in {{current_runtime}}. Current issues:
- {{performance_issue_1}}
- {{performance_issue_2}}

For each potential optimization (index, partitioning, materialized view, join reorder):
1. Explain the mechanism
2. Estimate runtime improvement
3. List trade-offs (storage, write performance, complexity)
4. Rank by effort-to-impact ratio

Did it work? Rate this prompt

Variables

Query description (joins, aggregations, etc.)

Number of tables

Total rows across tables

Current query runtime

First performance issue

Second performance issue

Details

Author

AI Khazna

License

—

Security

—

Type

prompt

Related assets

More curated picks in Data & Analytics.

prompt

Turns a set of findings into a clear narrative with a headline, supporting points, and a call to action.

Data Storytelling Builder

Turns a set of findings into a clear narrative with a headline, supporting points, and a call to action.0+

prompt

Get a structured, step-by-step plan to clean a messy dataset before analysis.

Data Cleaning Plan Generator

Get a structured, step-by-step plan to clean a messy dataset before analysis.0+

prompt

Plans a pivot table to answer a specific question from your data.

Pivot Table Planner

Plans a pivot table to answer a specific question from your data.0+

prompt

Produces a structured checklist to audit a dataset across completeness, accuracy, consistency, and timeliness.

Data Quality Audit Checklist

Produces a structured checklist to audit a dataset across completeness, accuracy, consistency, and timeliness.0+

prompt

Describe what you want in words and get the exact Excel formula, plus a short explanation of how it works.

Excel Formula Builder

Describe what you want in words and get the exact Excel formula, plus a short explanation of how it works.0+

prompt

Define the right KPIs, chart types, and layout for a dashboard that serves a specific goal and audience.

KPI Dashboard Planner

Define the right KPIs, chart types, and layout for a dashboard that serves a specific goal and audience.0+

Audit before you install

Run any source through our checks - AI visibility, security, performance, and stack detection.

Automated Web Security Scan

security

PageSpeed Analyzer

performance

AI Content Quality Test

arabic content

AI Agent / MCP Server Tester

ai testing

Site Stack Detector

migration

AI SEO / AEO / GEO Audit

ai visibility

llms.txt Generator

ai visibility

Readability Score

arabic content

Schema / JSON-LD Builder

ai visibility

AI Cost Calculator

ai testing

Headline Analyzer

arabic content