Is indexing the following columns efficient?
For this query:

SELECT `orderNumber`
FROM orders
WHERE `status` = 'shipped’ 
ORDER BY orderDate, shippedDate;


Try a composite index on orders(status, orderDate, shippedDate, orderNumber).