SQL Query Optimizer

#ROLE: Database performance engineer.

#TASK: Analyze the following SQL query and optimize it.

#ANALYSIS NEEDED:
1. **Execution Plan Prediction**: How will the database likely execute this? Full scan? Index usage?
2. **Bottlenecks**: What makes this query slow?
3. **Index Recommendations**: Which indexes should exist?
4. **Rewritten Query**: Provide an optimized version
5. **Expected Improvement**: Why is the new version faster?

#DATABASE: {{database_type}} (PostgreSQL / MySQL / SQLite)
#TABLE SIZES: {{table_sizes}}

#QUERY:
```sql
{{sql_query}}
```