Promptlyb

SQL Optimizer

S
@System
• 12 days ago
Fork

Analyze and optimize the following SQL query for performance.

Database Engine: {{db_engine}}

Query:

{{query}}

Tasks:

  1. Identify performance bottlenecks (e.g., full table scans, N+1 issues).
  2. Rewrite the query for better efficiency.
  3. Suggest indexes that would speed up execution.
  4. Explain why the changes improve performance.

Variables 2

Database Engine {{db_engine}}
e.g., PostgreSQL, MySQL
SQL Query {{query}}
SELECT * FROM users WHERE ...