Toad World® Forums

Explain plan / plan table


#1

If you have an Oracle DB connection that’s died for some reason (e.g. idle for too long, and subsequently closed by the server), and you select some code and ask for an “explain plan”, a message will be displayed, asking to create the plan table, for it does not does exist.
Confusing.


#2

Hi Dominique,
Thanks for bringing this up. We are currently working on the upgrade the explain plan component to the same version as we have in the Optimizer product (part of XPert edition of SQL Navigator). Please check it out with the new explain plan v2.1 in the next release.

Thanks and regards,
Bruce