How do you optimize a SQL query that is experiencing slow performance due to massive table joins and complex aggregations?
