Toad World® Forums

Include actual execution plan is not visible in EDITOR tab


Above the explain plan area, after you run a plan, it says either “New Explain Plan” or “Cached Explain Plan”.

Cached means it came from v$sql_plan, and this is what Oracle did to execute that query.

New means that the plan was not found, so Toad ran an “explain plan set statement_id = … for (your sql statement…)” command, and Oracle estimated how it would execute the query.