Re: EXPLAIN Feature

In article <jdennisCM1p9q.23F_at_netcom.com>, jdennis_at_netcom.com (John Dennis) writes:
>
> I'm trying to use the explain feature on Oracle 7.0. I'd could
> ask several questions but, trying not to look for the quick answer,
> I'd thought I'd ask where I might find more information on this
> feature. Oracle docs seem to focus only on explaining queries not
> evaluating the query USING the explain output.
> Any hints?
>

Chapter 13 of the ORACLE7 Server Concepts manual discusses the optimizer and describes how to evaluate the EXPLAIN PLAN output. Here is a SELECT command that we use to format the output to match what is described in the manual.

SELECT LPAD(' ',2*LEVEL)||operation||' '||

       options||' '||object_name QUERY_PLAN FROM plan_table
CONNECT BY PRIOR id = parent_id
START WITH id = 1
ORDER BY id
/

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285