Re: Index usage

From: Stan <stan0074_at_yahoo.com>
Date: Fri, 03 May 2002 19:37:03 GMT
Message-ID: <3CD2E7CB.608@yahoo.com>

Narendra,

Don't know, what oracle versions are you in, but start looking at stored outlines which is a perfect thing for this requirement. fyi, this feature is only available on enterprise editions of oracle.

hth,
-Stan

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:37:03 CDT