Hi Igor,
I assume that you haven’t used Dynatrace yet... In Dynatrace you can see the exact statement that is used to execute a query/modification, and in the context of the transaction. Hence you can see someone clicking a button and from there you can drill down to the individual sql statements for that specific user action.
Dynatrace does not offer a “replace this statement with this better statement” kind of function.
What I often do, is look at the troublesome statements (long running) and cut ‘n paste them to check in the (e.g. Oracle) client what the execution plan looks like. Based on that you (or the DBA) can help optimize the sql.
So no magical new statement generation, just a very accurate contextual view on the usage of your database.
Hope this helps.
Cheers,
Sjoerd
