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: Steve Adams <steve.adams_at_ixora.com.au>
Date: Sat, 14 Jun 2003 05:52:50 +1000
Message-ID: <20030613195250.GC32510@deuteronomy.ixora.com.au>


Hi Ryan,

The documented ones are explained at
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96533/hintsref.htm

The best way to get a list of all hints is to run strings(1) on $ORACLE_HOME/bin/oracle. However, I am not aware of a document anywhere that explains what they all do.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/          For DBAs
@   http://www.christianity.net.au/   For all


On 2003.06.14 02:49 Ryan Gaffuri wrote:
> I checked OTN and I checked metalink and I cannot find every SQL
> hint(including undocumented ones) located in the same place with a
> brief explanation for each.
>
> does anyone have a link to a list?
Received on Fri Jun 13 2003 - 14:52:50 CDT

Original text of this message

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