What is your approach to optimizing a slow-running SQL query that involves multiple large table joins?
