Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Most Performant way of performing sql query

Re: Most Performant way of performing sql query

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 25 Dec 2004 05:21:22 GMT
Message-ID: <pan.2004.12.25.05.21.22.839435@sbcglobal.net>


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.

-- 
Artificial Intelligence is no match for natural stupidity.
Received on Fri Dec 24 2004 - 23:21:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US