Westwing Group SE interview question

How do you optimize a slow running SQL query?