Prompt
Analyse this SQL query for performance issues. Provide: 1) Identify bottlenecks (full table scans, missing indexes, N+1 problems), 2) Rewrite the optimized query, 3) Suggest index creation statements, 4) Estimate performance improvement, 5) Note any potential data integrity concerns with the optimization. Database: [PostgreSQL/MySQL]. Table sizes: [approximate row counts]. Query: [paste query]
For image models
database query, terminal, dark theme, 16:9