Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Most Performant way of performing sql query
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
![]() |
![]() |