Re: Materialize hint

From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
To: "Mark J. Bobak" <mark@xxxxxxxxx>
Date: Sat, 25 Dec 2004 19:39:46 +0000

On 12/25/2004 12:42:49 AM, Mark J. Bobak wrote:
> Well, I'm certainly not Jonathan, however, I'd guess that the
> (apparently undocumented) MATERIALIZE hint does just that,
> materializes
> a query's result set at once, (perhaps into a temporary table?).

Yes, that's my understanding, too.

>=20
> As the the "with generator" clause, that I can answer with a bit more
> authority, since it IS documented.  It's refered to in the SQL
> reference
> manual as the "subquery factoring clause".


Thanks! This was a great tip. I've never used it, I didn't even know it =20
exists. Thanks for your help!

Merry Christmas!
--=20
Mladen Gogala
Oracle DBA


--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: Materialize hint
From: Connor McDonald

References:
- Materialize hint
  - From: Mladen Gogala
- Re: Materialize hint
  - From: Mark J. Bobak

Re: Materialize hint

Other related posts: