Whenever you're ready, walk me through how you'd approach this.
How would you optimize a SQL query that is performing poorly on a large dataset?