Re: Index usage

From: Richard Kuhler <noone_at_nowhere.com>
Date: Fri, 03 May 2002 19:43:14 GMT
Message-ID: <mLBA8.5645$M7.2351368@twister.socal.rr.com>

Well, If you're using RULE, you're going to have to get the other index to appear higher in the Rule Path algorithm. If the indexes are tied, you might try renaming them so the one you want it to use comes before the other alphabetically (rename IDX_A to IDX_C to get it to use IDX_B). However, this could also adversly impact other queries that would be better off using IDX_A.

Take a look at
http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a87503/rbo.htm#38893 for the Rule Path Algorithm.

Richard

"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
Received on Fri May 03 2002 - 14:43:14 CDT