Whenever you're ready, walk me through how you'd approach this.
Describe a time you had to optimize a slow-performing database query.
Explain how you diagnosed the bottleneck, evaluated possible solutions, coordinated with relevant stakeholders, and validated the improvement. Be prepared to discuss trade-offs, rollout safety, and how you monitored the result after deployment.