Re: Materialize hint

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 25 Dec 2004 19:39:46 +0000
Message-Id: <1104003586l.3814l.1l@medo.noip.com>

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

Received on Sat Dec 25 2004 - 13:35:09 CST