Re: Most Performant way of performing sql query

From: GreyBeard <Fuzzy.GreyBeard_at_gmail.com>
Date: Sat, 25 Dec 2004 10:41:32 GMT
Message-Id: <pan.2004.12.25.10.41.10.31986@gmail.com>

On Sat, 25 Dec 2004 05:21:22 +0000, Mladen Gogala wrote:

> On Thu, 23 Dec 2004 14:05:28 +0000, Jonathan Lewis wrote:
>

>> as
>> with generator as (
>>  select --+ materialize

>
> Jonathan, two questions:
> What does "materialize" hint do and where is it documented?
> The same question for "WITH GENERATOR AS" clause.
>
> I tried finding it in the documentation, but was unable to.

For the first, it's interesting that the only references I could find on Metalink are to the hint from Jonathan (272329.996 & 215086.995)

For the second, perhaps the "GENERATOR" is misleading as you search through the docco. It's just an alias. You should be looking for "WITH query_name", as in

	WITH query_name AS 
	SELECT ...

described in

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_103a.htm#2075668

and written up in http://www.oreilly.com/catalog/0596006322/

HTH.GB Received on Sat Dec 25 2004 - 04:41:32 CST