Re: /*+ ordered */

From: <michael_bialik_at_my-deja.com>
Date: Tue, 05 Oct 1999 21:32:54 GMT
Message-ID: <7tdqq7$jfn$1@nnrp1.deja.com>

Hi.

When using hints the optimizer is working in CBO mode and assumes some stats for all involved tables. Oracle CBO is biased toward best throughput ( contrary to best response time ).
Try using /*+ ordered first_rows */.

HTH. Michael.

In article <37F9C703.591E902_at_yahoo.es>, Edorta <edortta_at_yahoo.es> wrote:
> 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 */)
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 05 1999 - 16:32:54 CDT