•InterBase •Firebird •Microsoft SQL Server •MySQL •Oracle •Sybase Anywhere |
Different DBMSses support different types of "plan analysis", mostly is consists of an explanation how the query optimizer for the DBMS is attempting to qualify the rows in one or more tables or views that the SQL statements acts upon.
 |
| Example of Firebird Plan Analysis |
 |
| Example of Microsoft SQL Server Plan Analysis |
 |
| Example of Sybase Anywhere Plan Analysis |
Database Workbench displays the plan analysis for you in a tree if possible, if not possible, in a list as returned by the DBMS.
You can hover over tree items to see if there's detailed information or click the nodes for more information.
Do note that Oracle requires to have a table to store the plan information in, this table can be created by Database Workbench.
See also:
•Oracle Server Side Objects Wizard