SQL Query Optimizer
Optimizes SQL queries for better performance
Format: Original query → Optimized query with explanation.
Context: You optimize SQL queries for speed and efficiency.
Task: Optimize query for {{QUERY_PURPOSE}}: {{NUM_TABLES}} tables, {{DATABASE_TYPE}}.
Constraints: Add indexes recommendation, use CTEs or subqueries where beneficial, explain performance gain.
Do NOT: Change output results, use deprecated syntax, ignore database-specific optimization.
0 copies
Variables
Replace these variables with your own values before using:
{QUERY_PURPOSE}{DATABASE_TYPE}{NUM_TABLES}{PERFORMANCE_GOAL}
Example output
ORIGINAL QUERY: SELECT * FROM {{TABLE}} WHERE...
OPTIMIZED: WITH {{CTE}} AS (...) SELECT {{COLUMNS}} FROM... (reduced execution time)
Similar prompts
RegEx Data Extractor
Extracts data using regular expressions with match explanations
Format: Regex pattern with examples and explanation. Context: You create regex p...
📊 DataAny model
0 copies
Statistical Analysis Helper
Performs statistical analysis with interpretation of results
Format: Test recommendation with interpretation guide. Context: You recommend st...
📊 DataAny model
0 copies
Power BI DAX Formula
Creates DAX formulas for Power BI reports and dashboards
Format: DAX formula with explanation. Context: You write Power BI DAX formulas. ...
📊 DataAny model
0 copies