-
Title
Explain Plan window does not work when going to menu Database | Optimize | Explain Plan. -
Description
Explain Plan window does not work when going to menu Database | Optimize | Explain Plan. It does not display the explain plan. It only displays my SQL statement.
-
Cause
This window is to explore savd explain plans. Explain plan has not saved before.
-
Resolution
Go into the menu View | Toad Options | Oracle | General. Make sure the details for Explain Plan is correct and the Explain Plan exists. Also check the option "Save previous Explain Plan results." Save these options.
Go into the Editor window with your SQL Statement. Generate an explain plan by clicking on the Explain Plan icon or by pressing CTRL+E. This will populate an explain plan in the Editor window and it will be saved. If it does not populate, check your database permissions and if your explain plan settings are correct.
Now go into the menu Database | Optimize | Explain Plan. It should display your past executed explain plans. Click on the refresh icon if necessary.