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 -> /*+ ordered */

/*+ ordered */

From: Edorta <edortta_at_yahoo.es>
Date: Tue, 05 Oct 1999 11:38:11 +0200
Message-ID: <37F9C703.591E902@yahoo.es>


Hi,

I'm using the hint /*+ ordered */ in a query to try to force a particular order of tables to access. But when I do it, it doesn't use indexes although they exist and the query uses them if no hint is specified.

Is it /*+ ordered */ acting as one can expect? Should I try another way? (I wouldn't like to use /*+ index */) Received on Tue Oct 05 1999 - 04:38:11 CDT

Original text of this message

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