Le Mini-Cours du Jour

-- Exemple d'indexation optimisée
CREATE INDEX idx_customer_email ON customers(email);
CREATE INDEX idx_order_customer ON orders(customer_id);

-- Requête optimisée grâce aux index
SELECT c.name, COUNT(o.id) as order_count
FROM customers c
JOIN orders o ON c.id = o.customer_id
WHERE c.email LIKE '%.com'
GROUP BY c.name
HAVING COUNT(o.id) > 5;