Each time an Explain Plan is run, a dialog box displays asking to create a 'TOAD_PLAN_SQL' table. If user cancel this dialog, user gets the explain plan. Why is Toad asking to create this table, if I can still get the results, even though user doesn't create the table?
When the option "Save previous Explain Plan results" is checked in View | Toad Options | Oracle | General | Explain Plan, it will write to two tables - TOAD_PLAN_SQL and TOAD_PLAN_TABLE.
If either of these tables do not already exist, then you will be prompted to create the table. In the above scenario, TOAD_PLAN_TABLE does exist so the explain plan results can be written okay to there, even if you cancel the creation of the TOAD_PLAN_SQL table.
Both of these tables are required for displaying information in Database | Optimize | Explain Plan.
Click OK to create the TOAD_PLAN_SQL table.
