<< Click to Display Table of Contents >>

Explain plan

Top Previous Next

This modal dialog shows the execution plan for a select statement in an outline structure.

The dialog is based on the EXPLAIN PLAN SQL statement that requires the Data Dictionary table PLAN_TABLE. It can be created with the UTLXPLAN.SQL script that resides in the $ORACLE_HOME\rdbms\admin directory on the server. If you run the dialog without having a PLAN_TABLE, Hora will ask you to create the table. Because the structure of PLAN_TABLE may have changed from the previous Oracle version, we would recommend using the script on the server rather than creating it with Hora.

At the bottom of the window, you will see the optimizer mode of the current session. You can change it on the Database | Initialization parameters page.

The Close button closes the dialog without any action.