Prompt

Optimize SQL queries for maximum performance and efficiency:

**Query Analysis Framework:**
1. Execution plan analysis
2. Index utilization review
3. Join optimization strategies
4. Subquery elimination
5. Partition strategy implementation

**Optimization Techniques:**
- Index creation and management
- Query rewriting patterns
- Materialized view usage
- Statistics updates
- Parallel execution

**Performance Metrics:**
- Response time targets
- Resource consumption
- Scalability testing
- Monitoring setup
- Baseline comparisons

Current query:
```sql
{INSERT SQL QUERY}
```
Database system: {INSERT SYSTEM}