VIP 👤
🏠 Inicio
Pruebas de rendimiento
📊 Todos los benchmarks 🦖 Dinosaurio v1 🦖 Dinosaurio v2 ✅ Aplicaciones To-Do List 🎨 Páginas libres creativas 🎯 FSACB - Showcase definitivo 🌍 Benchmark de traducción
Modelos
🏆 Top 10 modelos 🆓 Modelos gratuitos 📋 Todos los modelos ⚙️ Kilo Code
Recursos
💬 Biblioteca de prompts 📖 Glosario de IA 🔗 Enlaces útiles 🔌 API y routers
advanced

Complex Query Optimization

#sql #database #optimization #performance

Optimize a poorly performing SQL query with multiple joins and subqueries.

Analyze the following poorly performing SQL query: 'SELECT * FROM Orders o JOIN Customers c ON o.customer_id = c.id WHERE c.country = 'USA' AND o.order_date > (SELECT MAX(order_date) FROM Orders WHERE customer_id = c.id) - INTERVAL '1 year';'. Identify the potential performance bottlenecks, including the type of join operations, the subquery execution, and the necessity of the wildcard select. Rewrite the query to optimize performance, explaining the specific indexing strategies you would recommend on the tables involved. Justify your changes using database theory concepts such as query execution plans and selectivity.