Database Query Optimizer

Optimize this SQL query:

Database: {DATABASE_TYPE}
Current query:
```sql
{QUERY}
```

Table sizes: {TABLE_SIZES}
Current execution time: {CURRENT_TIME}

Provide:
1. Optimized query
2. Index recommendations
3. Explain plan analysis
4. Performance comparison
5. Alternative approaches