Query Plan Analysis
|Previous Top Next|
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.
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.