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