Re: explain plan and sql ?

From: Steve Perry <sperry_at_sprynet.com>
Date: Mon, 12 Feb 2001 14:10:51 GMT
Message-ID: <L9Sh6.29607$iB1.2532893@typhoon.austin.rr.com>

I think you're talking about dumping the access path. I know how to do that. What I haven't seen is one where it maps each step of the plan to a line in your sql statement.

thanks anyway.

"Nuno Souto" <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message news:3a879eed.1312619_at_news-server...
> On Mon, 12 Feb 2001 05:46:19 GMT, "Steve Perry" <sperry_at_sprynet.com>
> wrote:
>
> >
> >I think Quest will show you, but I'm curious how they are able to map it
> >out, so maybe the question is how do they do it.
> >
>
> It's not a "secret". There is some example SQL in the ORACLE tuning
> manuals and pretty much all over the place. Involves the use of
> CONNECT BY.
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Mon Feb 12 2001 - 08:10:51 CST