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.

> 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!
Mladen Gogala
Oracle DBA


Other related posts: