help with index hint

From: <gdas_at_my-deja.com>
Date: Tue, 07 Nov 2000 23:04:40 GMT
Message-ID: <8ua1q4$a93$1@nnrp1.deja.com>

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. Received on Tue Nov 07 2000 - 17:04:40 CST