Re: "Data Path"

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 13 Jun 2001 23:10:13 -0700
Message-ID: <3B285544.D95B8D13@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...

No such tool exists as far as I know. But it is easy to tell which records came from which part of a union: Just add a string literal as an additional column.

Daniel A. Morgan Received on Thu Jun 14 2001 - 01:10:13 CDT