Re: Materialize hint

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Sun, 26 Dec 2004 01:33:33 +0000 (GMT)
Message-ID: <20041226013333.69293.qmail@web86901.mail.ukl.yahoo.com>

strings $ORACLE_HOME/bin/oracle
sql_trace = true for the whole database

is always a good start for seeing what hints are there. then its just a case of playing/guessing to see what you can come up with. There's some doozies in 10g

hth
connor

Mladen Gogala <gogala_at_sbcglobal.net> wrote:

>
> 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
>

Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"

Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250

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

Received on Sat Dec 25 2004 - 19:32:06 CST