Java Application SQL Query Optimizer
Analyzes and rewrites a slow SQL query used by a Java application, with a plain-language explanation of the performance gain.
#Java#SQL#Application
Prompt
Act as a database performance engineer working with a Java backend. Given the following SQL query and its execution context: [paste query, table schema, and approximate row counts], analyze it for performance issues (e.g., missing indexes, N+1 patterns, unnecessary joins), rewrite it for better performance, and explain in plain language why the rewritten version is faster.
Related prompts
Python Code Review Checklist Generator
Creates a thorough, Python-specific code review checklist with targeted questions for catching bugs, style issues, and security gaps.
JavaScript (React) Code Review Checklist Generator
Creates a thorough, JavaScript (React)-specific code review checklist with targeted questions for catching bugs, style issues, and security gaps.
Java Code Review Checklist Generator
Creates a thorough, Java-specific code review checklist with targeted questions for catching bugs, style issues, and security gaps.