SQL Query Optimization Analyzer

Analyze this SQL query and provide optimization recommendations:

**Query:**
```sql
{{SQL_QUERY}}
```

**Table Schema:**
```sql
{{TABLE_SCHEMA}}
```

**Current Execution Time:** {{CURRENT_EXECUTION_TIME}}
**Database System:** {{DATABASE_SYSTEM}}

Please provide:
1. Query analysis identifying performance bottlenecks
2. Optimized version of the query
3. Recommended indexes to create
4. Explanation of why each optimization improves performance
5. Estimated performance improvement
6. Alternative query approaches if applicable