Re: explain plan and sql ?

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Mon, 12 Feb 2001 08:40:47 GMT
Message-ID: <3a879eed.1312619@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 - 02:40:47 CST