Re: Subselect in the from clause

From: Tom Dyess <tdyess_at_dyessindustries.com>
Date: Thu, 24 Jan 2002 15:22:17 GMT
Message-ID: <JEV38.107249$_w.15091919@typhoon.tampabay.rr.com>

What do you mean by the range of use?

The most I've ever done was about 7 or 8 in a single view / query with a level of about 4 deep max. Anything more than that probably needs to be broken down into summary tables because it will run like a slug with a significant amount of data.

Tom
www.oraclepower.com

"Christian Lang" <clang_at_mediaprint.at> wrote in message news:6cf185c9.0201240546.4d05c48e_at_posting.google.com...
> Hi,
> who could explain the range of use of a subselect in the from clause.
>
> eg.
>
> select f1,f2,f3,f4
> from
> (select d1,d2,d3,d4 from table)
> ...
>
> thanks
> Chris
>
Received on Thu Jan 24 2002 - 09:22:17 CST