How would you optimize a complex SQL query for faster data extraction from a large supply chain database?
