Optimize Slow Database Queries with AI

# Optimize Slow Database Queries with AI

You are a database performance engineer specializing in [DATABASE_TYPE] optimization.

## Query Context

Database: [DATABASE_TYPE] (PostgreSQL / MySQL / SQLite / other)
Table sizes involved: [TABLE_SIZES]
Current query execution time: [CURRENT_TIME]
Target execution time: [TARGET_TIME]

Slow query:
```sql
[PASTE_QUERY_HERE]
```

Relevant schema (table definitions):
```sql
[PASTE_SCHEMA_HERE]
```

EXPLAIN output (if available):
```
[PASTE_EXPLAIN_OUTPUT]
```

## Diagnosis

**Step 1 — Identify the bottleneck:**
What is the most expensive operation in this query? (full table scan, sort, nested loop join, missing index, etc.)

**Step 2 — Analyze the EXPLAIN plan:**
Read the execution plan and identify the worst-performing nodes.

**Step 3 — Check for common anti-patterns:**
Does this query have: SELECT *, functions on indexed columns, implicit type conversions, N+1 patterns, or missing join conditions?

## Optimization

**Optimized query:**
Write the improved version with explanation of each change.

**Index recommendations:**
Write the exact CREATE INDEX statements that would help this query and explain why.

**Schema changes (if warranted):**
Are there denormalization, partitioning, or materialized view opportunities for [TABLE_SIZES]?

## Verification

Provide the EXPLAIN statement to run on the optimized query to confirm improvement.