Whenever you're ready, walk me through how you'd approach this.
Describe a time you optimized a slow-running query.
Explain how you diagnosed the bottleneck, what changes you made, and how you verified that the optimization improved performance without changing the results. Discuss relevant trade-offs, such as index maintenance, data volume, and query readability.