prompt
SQL Performance Optimizer
Analyze slow SQL queries to identify bottlenecks (missing indexes, poor joins, large scans) and provide optimization recommendations with expected performance gains.
Updated June 2026
The prompt
This query runs in {{current_duration}} but we need it under {{target_duration}}: {{query_text}}. Analyze for: 1) query execution plan issues, 2) missing or inefficient indexes, 3) table scan opportunities, 4) join optimization possibilities, 5) data type mismatches. Provide rewritten query, index creation statements, and estimated execution time improvement with percentage gains.
Did it work? Rate this prompt
Variables
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