Prompt

Optimize database queries and schema for performance.

<slow_queries>
{paste problematic SQL queries}
</slow_queries>

<schema>
{relevant table definitions}
</schema>

<query_plans>
{EXPLAIN output if available}
</query_plans>

Optimize:
1. Index recommendations
2. Query rewriting
3. Denormalization opportunities
4. Caching strategies
5. Schema improvements