Re: Materialize hint
- From: Connor McDonald <hamcdc@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 26 Dec 2004 01:33:33 +0000 (GMT)
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
>
>
> --
> //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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
