Query Optimization Advisor
Transform slow database queries into high-performance operations with this AI prompt, focusing on execution plan analysis and targeted optimizations.
What this prompt does
- Analyzes slow queries to identify inefficiencies and bottlenecks in execution plans.
- Provides targeted optimization strategies to improve query performance using advanced techniques.
- Validates improvements by comparing execution plans before and after optimization.
How to use this prompt
- Run the full prompt and answer the questions as detailed as possible.
- Example: "My slow query is a SELECT statement with multiple joins and subqueries. My table structures include several large tables with millions of rows. My database system is PostgreSQL 13. My current execution plan shows full table scans and nested loop joins. My performance requirements are su…
Premium prompt — included in the Complete AI Bundle. Part of the Coding prompts collection in the God of Prompt library.