Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index question
Hi!
Hm, what happened to insert hints.. such APPEND,
PARALLEL, NOLOGGING etc..?
I would avoid this "dbasupport" site, it has
written *a lot* of crap before.
Check this for example (Tom Kyte's
comments on an dbasupport article :)
<A
href="http://asktom.oracle.com/pls/ask/f?p=4950:8:345702010955165697::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:4951966319022">http://asktom.oracle.com/pls/ask/f?p=4950:8:345702010955165697::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:4951966319022,
Tanel.
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
Sent: Wednesday, June 25, 2003 11:16
PM
Subject: Re: Index question
I found the next link, that shows you how
to specify and index to determinated table.
<A
href="http://www.dbasupport.com/oracle/ora9i/index_hints.shtml">http://www.dbasupport.com/oracle/ora9i/index_hints.shtml
This is a fragment of the article:
How to specify Hints
The Hints are enclosed in comment, /* comment */, in an SQL statement, and
can only be specified with SELECT, DELETE and UPDATE keyword.SELECT /* comment */ ........ ;
Received on Wed Jun 25 2003 - 15:11:17 CDT