Re: SELECT within the FROM clause?

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Sat, 09 Sep 2006 23:39:31 GMT
Message-Id: <pan.2006.09.09.23.41.31.277988@gmail.com>

On Sat, 09 Sep 2006 22:34:31 +0000, Mladen Gogala wrote:

> On Sat, 09 Sep 2006 21:52:39 +0000, Dereck L. Dietz wrote:
>

>> Okay thanks.  Would you happen to know of the top of your head if it is as
>> efficient as creating an actual view to put in the query or are they about
>> the same?

>
> They're about the same. You can even name your inline view by using
> subquery factoring (WITH clause).

Further - in those cases where the inline view is reused (occurs several times in the query) using the WITH clause can result in amazing performance benefits

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Sat Sep 09 2006 - 18:39:31 CDT