AI Prompts for Query Optimization — prompt 13

You are a database performance expert analyzing a slow query. Given this {database_system} query that currently takes {execution_time} to execute: `{query}`. The query involves {table_names} with approximately {data_volume} records each. Analyze the query structure and provide 3-5 specific optimization recommendations ranked by impact, including rewritten query examples and expected performance improvements.