Re: help with index hint

In our lasat gripping episode gdas_at_my-deja.com wrote:
> I've done this many times before, but for some reason, it just won't
> work today and I can't understand it.
>
> I'm trying to specify an index hint to use a specific index in a
 table,
> and oracle is simply ignoring my hint and not using the index I'm
> telling it to.
>
> My looks like this:
>
> SELECT /*+ INDEX(RUN RUN_ACCT_ID_IDX) */
> COUNT(RUN_ID),MAX(RUN_ID),AVG(RUN_ID)
> FROM
> RUN A WHERE A.ACCOUNT_ID = 723 AND A.STATUS = 'OK';
>
> When I run an explain plan on this statement, it doesn show the
> specified index in the hint being used.
>
> Did I do incorrectly specify the hint? I'm stumped.
> By the way, this is on 8.1.5.
>
> Any ideas appreciated,
> Gavin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Please provide the query plan -- seeing both the query and the execution plan Oracle is using will go a long way to help explain this behaviour.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.