AI Prompts for Query Optimization — prompt 14

Act as a database architect reviewing indexing strategy for {database_system}. Here's a query: `{query}` running against tables {table_names} with {data_volume} records. Analyze the current execution plan and recommend optimal index configurations, including composite indexes, covering indexes, and any schema adjustments. Provide the exact CREATE INDEX statements and explain the performance rationale for each recommendation.