Query Plan Analysis

Previous  Top  Next

Supported for
Microsoft SQL Server
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