Amazon Web Services
Part of Amazon
Is this your company?
Amazon Web Services Interview Question
How would you diagnose slow performance of a database query?
Interview Answer
Anonymous
Aug 16, 2022
Multiple ways to diagnose this, depending on which database you are using. First step would be to look at a query execution plan; another step would be to dis-assemble the query part by part and see where bottlenecks occur.