Essa empresa é sua?
How would you diagnose slow performance of a database query?
Sigiloso
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.