How would you optimize a slow-running SQL query that processes millions of rows in an Akamai analytics workload?