Query Plan Analysis

Previous  Index  Next  How To Use

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.


Firebird Plan Analysis
Example of Firebird Plan Analysis


Microsoft SQL Server Plan Analysis
Example of Microsoft SQL Server Plan Analysis


Sybase Anywhere 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