Execution plan perspective

Execution plan perspective allows users to show the execution plan of a query. Currently, the perspective only supports Oracle and PostgreSQL execution plans.

You can switch to the perspective using the toolbar button or “Window” menu.

The execution plan perspective consists of the same database explorer and SQL editors as those in the query perspective. In addition, it has an “Execution Plan” view to display execution plans in a tree structure.

You can highlight a query in a SQL editor window, and click the “Execute” tool bar button to display the execution plan of the query. If you highlight several SQL statements, only the last statement’s execution plan will be displayed.

The following shows a screen shot of the execution plan perspective. The execution plan displayed is for a query running in the Oracle database. For the Oracle execution plan to work, you need to create the PLAN_TABLE in the corresponding database. The script for creating PLAN_TABLE is “utlxplan.sql” under directory “$ORACLE_HOME/rdbms/admin”.

The following shows an execution plan for PostgreSQL database:

For other types of databases, if they support an “explain” command, you can run the command in the “Query Perspective” to see the execution plan.