Aledade interview question

How would optimize a slow running SQL query?