Whenever you're ready, walk me through how you'd approach this.
How do you optimize a slow-running query?