Relational Query Profiling & Indexing
Restructures slow queries, predicts scan types, and suggests indices.
Shared by booth4ai
Prompt Instruction
Review this slow SQL query running on [Engine: PostgreSQL/MySQL]. Explain the query execution path, highlight expensive operations (table scans, large joins), and rewrite it for optimal index utilization: ```sql [Insert Slow Query Here] ```
Tip: replace anything in [brackets] with your own details before running the prompt.