Explain how you would optimize a slow-performing database query in a high-traffic application.
Utilisateur anonyme
I discussed analyzing the query execution plan, checking for missing indexes, and considering database normalization/denormalization trade-offs. I also mentioned caching strategies and query refactoring to reduce load times.