Toad World® Forums

Execution plan always new


CTRL+E should give cached plan if possible, estimated if not.

Right click in Explain plan area, "load cached plan if possible" is selected.

I run my SQL so it should be cached, then CTRL+E, but I see "new plan" every time just above the Explain plan dialog. My understanding was once its ran and cached it should be taking the cached execution plan.

It works for me, see below (It's not the exact version as yours but very close). I am guessing that it's looking for a cached plan but not finding it. The SQL text has to be exactly the same as a prior executed SQL.

You can always turn on spool SQL (Database -> Spool SQL -> Spool to Screen) to see what Toad is doing.