I'm working on an SQL query for a complex reporting system that involves multiple tables and joins. However, the query's performance is not meeting my expectations, and I suspect that the way I've structured my joins might be inefficient.


Here's a simplified version of my query:

SELECT
    orders.order_id,
    customers.customer_name,
    products.product_name,
    order_details.quantity,
    order_details.unit_price
FROM
    orders
JOIN
    customers ON orders.customer_id = customers.customer_id
JOIN
    order_details ON orders.order_id = order_details.order_id
JOIN
    products ON order_details.product_id = products.product_id
WHERE
    orders.order_date BETWEEN '2023-01-01' AND '2023-12-31';
While this query returns the correct results, it's taking a significant amount of time to execute, especially when dealing with a large dataset.


I'd like to optimize this query for better performance. Could someone review my SQL code and suggest improvements or alternative approaches to achieve the same result more efficiently? Additionally, are there any indexing strategies or database design considerations that might help enhance the query's speed? Any insights or code optimizations would be greatly appreciated. Thank you!