Re: Materialize hint

1) strings $ORACLE_HOME/bin/oracle
2) 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@xxxxxxxxxxxxx> 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@xxxxxxxxx

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

Other related posts: