3. Weak Structure

"Help me optimize this database query:
1.
First, analyze the current query performance:
   [Query and execution plan]
2.
Identify the specific bottlenecks:
- Table scans
- Missing indexes
- Suboptimal joins
3.
Recommend specific optimizations:
- Index suggestions
- Query restructuring
- Configuration changes
4.
Provide an optimized version of the query with explanations of each change"