Materialize hint 2004-12-25 - By Mladen Gogala
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
|
|
