Toad World® Forums

How do I save the Explain Plan

I added a table to my schema called plan_table and checked the save explain plan option. It does not write the explain plan to the table. What am I doing wrong.

Check this box:

Go to the editor, type in your statement, do a CTRL+E to explain plan:

This dialog should appear (only on the first explain plan) to prompt to create the table to store the plans. Just click OK.


To see the saved plans, go to the main menu. Database -> Optimize -> Explain Plan.