Re: Explain Plan

Or better find some software that helps you to read that execution plan.

> In *general* you read inside out with the results of the inner operation
> providing the input rowset for the outer operation. If you are running
> TKPROF with the explain= parameter don't, the plans it gives are those
> that would be executed if the statement ran now in the environment as it
> is now for the user you use to explain it. The only way to get the plan
> that actually was executed is to use the STAT lines (which is what
> tkprof does if you don't use explain= ) in the trace file or to query
> v$sql_plan if you have that view in the version you are running.
Received on Thu Feb 10 2005 - 19:21:50 CET