Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Where can I get a complete list of all SQL Hints?

Re: Where can I get a complete list of all SQL Hints?

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Sat, 14 Jun 2003 10:17:09 -0700
Message-ID: <3EEB5895.B50052D@exxesolutions.com>


Ryan wrote:

> thanks... Ill start playing with the undocumented ones to see what they do.
> do you know if anyone has written an article about undocumented hints?
> "Franklin" <member29243_at_dbforums.com> wrote in message
> news:3002068.1055563166_at_dbforums.com...
> >
> > You can use grap and strings to get them directly from the Orale
> > executable:
> >
> > strings $ORACLE_HOME/bin/oracle> hints.lst
> >
> > Oracle9i r2 documented hints:
> >
> > <snipped>
> >
> > --
> > Posted via http://dbforums.com

Those that resort to undocumented 'solutions' generally haven't invested 1/10th the effort required to fix the problem with the documented ones.

Rethink your strategy. Likely you will just make an unsupported mess.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sat Jun 14 2003 - 12:17:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US