SQL-Minimierung & Abfrage-Optimierung

SELECT/*+INDEX(o idx_orders_customer_date)*/o.order_id,c.company_name AS customer_name,c.tax_identifier,SUM(oi.quantity*oi.unit_price)AS total_gross_amount,COUNT(DISTINCT oi.item_id)AS distinct_sku_count,MAX(o.created_at)AS latest_transaction_timestamp FROM orders o INNER JOIN customers c ON c.id=o.customer_id LEFT JOIN order_items oi ON oi.order_id=o.order_id WHERE o.status IN('COMPLETED','SETTLED')AND o.created_at>='2024-01-01 00:00:00' AND c.is_test_account=0 GROUP BY o.order_id,c.company_name,c.tax_identifier HAVING SUM(oi.quantity*oi.unit_price)>50.00 ORDER BY total_gross_amount DESC LIMIT 100;