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 -> Re: Index usage

Re: Index usage

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 03 May 2002 19:30:02 GMT
Message-ID: <3CD2E538.4B9C194F@exesolutions.com>


"Guruju,Narendra" wrote:

> With out putting a hint in the query, is it possible to make a query
> choose a particular index. The query is in a 3rd party application and
> can not be modified, but the testing shows that if it uses a different
> index on the table, it would run lot faster. Also the optimizer mode
> used by the application is RULE.
>
> TIA,
> Narendra

What version of Oracle?

Daniel Morgan Received on Fri May 03 2002 - 14:30:02 CDT

Original text of this message

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