Re: Materialize hint

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

Other related posts: