Re: "Data Path"

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 13 Jun 2001 17:57:05 -0700
Message-ID: <3B280BE1.9146F2DF@exesolutions.com>

Andreas Koch wrote:

> Hi,
>
> if i have a pretty large select statement, with lots of
> wheres and unions and views- are there tools that help to analyze this?
>
> Especially i would like to have a "automagic" way to check
>
> -from which UNION-ed part a certain result line came
> -what WHEREs caused a certain result line NOT to appear
>
> --
> Andreas
> Seeing Dune worms, i don't want to see the Dune BIRDS...

Oracle comes with a built in facility called EXPLAIN PLAN. Look it up on technet or in your documentation.

Also look up TKPROF.

Daniel A. Morgan Received on Wed Jun 13 2001 - 19:57:05 CDT