Materialize hint 2004-12-25 - By Connor McDonald
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@(protected) > 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@(protected)
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
|
|
