How would you optimize a SQL query that joins multiple large tables and must return results quickly for reporting?
