DBA tools can identify slow queries affecting DB response times. But this information is often useless for developers, as they usually cannot locate the origin of such a query in their code. In such cases, poor performing SQLs remain unchanged in the code.
By combining SQL execution statistics with a static analysis of the code, Visual Expert can go further and pinpoint the procedures or functions where the SQL should be improved.
You can review the queries accessing a table to identify performance issues:
This feature comes with 2 parameters to let you customize it (click the small wrench on the right to set them):
Once you identified a slow query, you can find the procedure that generated it, and review its source code: