Database Workbench provides you with a visual query-plan analyzer. Not only with every ad-hoc query in the SQL Editor, but also in the Stored Procedure Editor, where your procedure source code is parsed, analyzed to seperate DML statements and executed to retrieve the query plan.
The visual plan analyzer will show "natural" table access in red and shows easy to understand images for a quick look. It will also display the indices used by statements and a detailed description of each "access plan".
Furthermore, it shows the "plan tree" - a graphical representation of the full query plan in different parts, basically this is how the server is processing your query.
|
 < |
